Hi, I have been using vlookup, but not able to get this one to work.
It seems quite straightforward, but somehow I cant figure out why.... can please enlighten. attached is the working file.
thanks in advance.
Hi, I have been using vlookup, but not able to get this one to work.
It seems quite straightforward, but somehow I cant figure out why.... can please enlighten. attached is the working file.
thanks in advance.
Column B = Number
Column E = Text (noted by the green triangle in top left hand corner
you cant looking number in text field
https://exceljet.net/formula/vlookup...mbers-and-text
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Column E is text, column B is number
Try this ...
=VLOOKUP(B2&"",$E$2:$G$30,3,FALSE)
That's quick! Thank you all!
You're welcome!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks