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!
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!
Thanks,
R.
Hi,
Try this in F2 and down:
=INDEX(A:A,MATCH(E2,B:B,0))
Last edited by Limor_OP; 09-14-2020 at 10:00 AM.
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
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
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.
Hi both,
I`m still getting #NA error..
Trying to see if data from column E is in column B. thank you
I added the file to my post #2
So use this formula:
=VLOOKUP(E2,B:B,1,0)
thanks belind afor the file!
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?
@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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks