Help with VLOOKUPIF formula

[Peter_D1972]

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.

[#2 · Accepted solution]

@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.

[#3]

Thank you Riny - I am a bit of a formula novice as you can tell!