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)