Forum Discussion
Help with VLOOKUPIF formula
Hi - I need to produce a table like the first image using the data from the second but I am gettting confused as to what exact formula to use for this to work.
I definitely need to use the IF feature and I am thinking in conjuction with VLOOKUP but looking for advice to put the correct formulas together so that the cells are populated correctly.
I want to use the finished table to produce a scatter chart with split data.
Peter_D1972 Well, the quick tip tells it all. Look into the help section for the IF function.
=IF(logical_test, value_if_true, value_if_false)
In your example the logical test in E2 would be:
B2="Y"
value if true:
D2
value if false:
NA()
I trust you can figure out how to write the formula and apply similar ones to the other columns.
2 Replies
Peter_D1972 Well, the quick tip tells it all. Look into the help section for the IF function.
=IF(logical_test, value_if_true, value_if_false)
In your example the logical test in E2 would be:
B2="Y"
value if true:
D2
value if false:
NA()
I trust you can figure out how to write the formula and apply similar ones to the other columns.
- Thank you Riny - I am a bit of a formula novice as you can tell!
