VLOOKUP Help

[gregc72]

I have two different reports that I get. Im combining them into two sheets and doing a VLOOKUP to Match Incident #'s in each with a PCR # in one of the sheets. Everything I get back is either #REF or #N/A. The #N/A appears to be because it's not finding a record that matches but I can't understand why I'm getting the #REF.
I've attached the sheet for reference. Would greatly appreciate some help.
Thanks in advance.

[AlKey]

Try this one

=IFERROR(VLOOKUP(A2,'EMEDS 2014-05'!$A$2:$C$524,3,0),"Not Found")

[Jonmo1]

The REF errors are because your lookup range is only 1 column $A$2:$A$524
But you're trying to return a value from the 3rd column..There is no 3rd column in $A$2:$A$524
So that should probably be $A$2:$C$524

Formuila in C2 should be
=VLOOKUP(A2,'EMEDS 2014-05'!$A$2:$C$524,3,0)

And you're correct, the #N/A's are because there is no matching value in the source sheet.

[gregc72]

Alkey, I was getting there once I got it to work. Thanks, Jonmo1, that was it, first time using VLOOKUP and I thought the range was the range in which you were comparing values and then by selecting the index you indicated which column you wanted the value out of. I thought wrong. I now understand. Thank you both for your help!

[Jonmo1]

You're welcome.