If Range contains Value then Display Adjacent Cell

[Kapz]

Hi Guys,

I am copy and pasting 2 sets of data into "Column E" and "Column F"

What I want is to filter some of the data and display the adjacent cells value in "Column B":

Eg. for cell B7: If E7:E53 contains "N1" then display adjacent cells value into cell B7
for cell B8: If E7:E53 contains "N2" then display adjacent cells value into cell B8

Once Column B is populated Column C will be able to cross reference and display the data from the second tab (employee names)

Any idea's?

[bhenlee]

wouldn't vlookup do the same trick?

[Kapz]

wouldn't vlookup do the same trick?

Not sure - how do you get it to show adjacents cell value not the value it is searching in?

[Sam Capricci]

maybe something like this... =VLOOKUP(A7,$E$7:$F$53,2,FALSE) dragged down will work for you.

[Kapz]

maybe something like this... =VLOOKUP(A7,$E$7:$F$53,2,FALSE) dragged down will work for you.

So far so good, many thanks!