Hi
I have been using Vlookup for some time now, but am completely stuck with this formula.
I understand that you cannot lookup column C, and return the value in column A, so i have tried using Index and Match.
Here's what i need to do
Lookup Cell C1469 within Column D and Return Column A
Unfortunately i cannot rearrange the columns as a macro needs to run which pulls data in a specific format. The formula i have tried is as follows...
=INDEX(A:A,MATCH(C1469,D:D,0))
After some research, i cannot see why this does not work (always returns #N/A)
Bookmarks