VLOOKUP not retunring data

[rayted]

hi guys

Column E in my sheet has less data compared to my range but it is not returning data from column b? can someone help>


thanks!

[Limor_OP]

Hi,

Try this in F2 and down:
=INDEX(A:A,MATCH(E2,B:B,0))

[sweep]

Hi,

Are you trying to lookup in Column B and return column A?

If so, try this:

=INDEX($A$2:$A$590,MATCH(E2,$B$2:$B$590,0))

Note that you can't VLOOKUP to the left

[Limor_OP]

Your error was that you were searching the value on column A whereas is resides on column B
Since Vlookup cannot search column B and return A (unnatural direction), you should use the index/match functions.

[rayted]

Hi both,

I`m still getting #NA error..

[rayted]

Trying to see if data from column E is in column B. thank you

[Limor_OP]

I added the file to my post #2

[Limor_OP]

So use this formula:
=VLOOKUP(E2,B:B,1,0)

[rayted]

thanks belind afor the file!

[Pepe Le Mokko]

So use this formula:
=VLOOKUP(E2,B:B,1,0)

What's the point in looking up a value in the column where it already is?

@rayted
Be aware that using entire column/rows references is bad practice

[Limor_OP]

Hi Pepe Le Mokko,
Don't understand your observation...he is searching E on B....it's not the same column.
am I missing something?

[Pepe Le Mokko]

@Belinda
Your lookup range is col B and the value should be looked up in column 1 which is also col B:B Your solution will return E2 or NA