Search
Search

Update a column based on the value of other column

debugcn Published at Dev
19
Arijit Biswas

My excel sheet looks like below.

I would like place value of 2 in column C if complexity level is Difficult. If low then 0.5 and if medium then 0.75.

Please let me know if there is any formula available or I have to write a marco for the same.

Scott Craner

IN C2:

=IFERROR(INDEX({2,0.75,0.5},MATCH(B2,{"Difficult","Medium","Low"},0)),"Not a Choice")

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Java

Replace column value based on value in other column

From Dev

Postgresql Trigger based on value of one column to change or update value of other column in each row.

From Dev

Update a Value in One Column Based on Criteria in Other Columns

From Dev

Update a column based on its current value

From Dev

Update a column based on other values in the row

From Dev

Update a column based on other column with postgresql

From Dev

Using CASE to update column value depending on other column values

From Dev

Group by query based on other column value

From Dev

R - Update a Value in One Column Based on Criteria in Other Tables

From Dev

How to decreasing value based on other column in SQL

From Dev

Update column value in XTS object based on date

From Dev

SELECT with temporary column with value based on other column

From Dev

Determine column value based on 2 other columns

From Dev

Update column value that has one or more same values of other column

From Dev

Query column based on presence of value in other columns

From Dev

Conditional Formatting on column based on other column value

From Dev

Update value in column based on other column values in Spark

From Dev

Update column only if value doesnt exist in other column

From Dev

update column with other column

From Dev

Update table column based on columns in other table

From Dev

UPDATE sql column with value from another column based on a date column

From Dev

Want to update other column field values based on the new edited value on my grid rally

From Dev

Return the occurance of a value in a column based on other values

From Dev

SELECT with temporary column with value based on other column

From Dev

How to update value in column cells based on other column cells in the same csv file bys using python?

From Dev

R set column value to be other column value based on string search

From Dev

Create a column based on other columns value

From Dev

Update a row if a column value is not the same on other table

From Dev

Update value of other column on update of this column

Related Related

  1. 1

    Replace column value based on value in other column

  2. 2

    Postgresql Trigger based on value of one column to change or update value of other column in each row.

  3. 3

    Update a Value in One Column Based on Criteria in Other Columns

  4. 4

    Update a column based on its current value

  5. 5

    Update a column based on other values in the row

  6. 6

    Update a column based on other column with postgresql

  7. 7

    Using CASE to update column value depending on other column values

  8. 8

    Group by query based on other column value

  9. 9

    R - Update a Value in One Column Based on Criteria in Other Tables

  10. 10

    How to decreasing value based on other column in SQL

  11. 11

    Update column value in XTS object based on date

  12. 12

    SELECT with temporary column with value based on other column

  13. 13

    Determine column value based on 2 other columns

  14. 14

    Update column value that has one or more same values of other column

  15. 15

    Query column based on presence of value in other columns

  16. 16

    Conditional Formatting on column based on other column value

  17. 17

    Update value in column based on other column values in Spark

  18. 18

    Update column only if value doesnt exist in other column

  19. 19

    update column with other column

  20. 20

    Update table column based on columns in other table

  21. 21

    UPDATE sql column with value from another column based on a date column

  22. 22

    Want to update other column field values based on the new edited value on my grid rally

  23. 23

    Return the occurance of a value in a column based on other values

  24. 24

    SELECT with temporary column with value based on other column

  25. 25

    How to update value in column cells based on other column cells in the same csv file bys using python?

  26. 26

    R set column value to be other column value based on string search

  27. 27

    Create a column based on other columns value

  28. 28

    Update a row if a column value is not the same on other table

  29. 29

    Update value of other column on update of this column

HotTag

Archive