VLOOKUP #N/A Error

Hi Team,

I'm usually fine with VLOOKUPS. Maybe I am just staring at a screen too long.

The formula I'm using appears to be correct to me but does not want to play ball. I have attached the example in this thread post.

=VLOOKUP(G4,ACR!A2:B28022, 1, 0)

I am in cell D4. Trying to reference G4 on a different sheet ACR!
G4 contains an ID number.

In ACR! The ID number is next to the name of a Crewmember (fictional).

So the VLookup should pull the name when typing in the correct Crewmember(CM) ID Number.

Can I have some help please?

your range is A:C
BUT the Value you are trying to match with is in B
so range should be B:C
=VLOOKUP('911 Template'!G4,ACR!B:C,1,TRUE)

What are you trying to Return the same value or Location
AND TRUE would be nearest lower value

Thanks for the quick reply! Sorry if I didn't explain what I was trying to do.

- I'm using the ID to autopopulate the Name of the crewmember. Not the ID itself if that makes sense?

VLOOKUP() searches the leftmost column of lookup_table. Your crewmember numbers are not in the leftmost column of your lookup table (they are in the second column). You need to either rearrange your lookup table in ACR so that crewmember ID# is the leftmost column or you need to use INDEX(...MATCH()) or XLOOKUP() [if available to you] or some other strategy that allows you to search a column other than the leftmost.

Hi MrShorty!

You nailed it. Thank you!!! I knew I was looking at the screen for too long.