When using vlookup why are some of the values coming up as N/A when the data is correct

1. When using vlookup why are some of the values coming up as N/A when the data is correct

Hi,

I don't understand why some of the values are showing the data but others are coming up as N/A. I noticed on those that said N/A if I changed the end of the formula to TRUE (instead of False) a value appears - although not the correct value.

Here is the formula I am using:

=vlookup(A3,'Active SKU'!B1:G,2,FALSE) and also tried =vlookup(A3,'Active SKU'!B1:G137,2,FALSE)

Appreciate and help (and again I am very new to this so if you could explain it in layman's terms I would be very greateful)

Thank you!

2. Re: When using vlookup why are some of the values coming up as N/A when the data is correc

=vlookup(A3,'Active SKU'!B1:G,2,FALSE)
You are missing the bottom row in column G: B1:Gxx

3. Re: When using vlookup why are some of the values coming up as N/A when the data is correc

I tried that and it didn't seem to work

4. Re: When using vlookup why are some of the values coming up as N/A when the data is correc

Did you fix the row? VLOOKUP(A3,'Active SKU'!B\$1:G\$XX,2,FALSE)

5. Re: When using vlookup why are some of the values coming up as N/A when the data is correc

YESSS!! Thank you! Can I ask... what do the \$ signs do? I want to make sure I can learn for next time

6. Re: When using vlookup why are some of the values coming up as N/A when the data is correc

Shot List

B3=IFERROR(VLOOKUP('Shot List'!\$A3,'Active SKU'!\$B\$2:\$G\$200,2,FALSE),"")

Copy down

7. Re: When using vlookup why are some of the values coming up as N/A when the data is correc

This is the relative and absolute cell address.

The \$ sign is to fix the row or column number so that when you copy down or across, the row or column number will stay the same.

in your example say, A1=VLOOKUP(A3,'Active SKU'!B\$1:G\$100,2,FALSE), if there is no \$ sign and you copy down the formula to cell A2, the formula will change to VLOOKUP(A3,'Active SKU'!B2:G101,2,FALSE)

There are currently 1 users browsing this thread. (0 members and 1 guests)