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

**beesutts5445** · 09-28-2021, 11:57 PM

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!

**protonLeah** · 09-29-2021, 12:13 AM

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

**beesutts5445** · 09-29-2021, 12:35 AM

I tried that and it didn't seem to work

**josephteh** · 09-29-2021, 01:11 AM

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

**beesutts5445** · 09-29-2021, 01:16 AM

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

**CARACALLA** · 09-29-2021, 01:21 AM

Shot List

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

Copy down

**josephteh** · 09-29-2021, 01:21 AM

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)

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Run VLOOKUP only for data coming from a particular source

[SOLVED] Vlookup not returning correct values

[SOLVED] How to ensure the coming data is correct?

Why are my averages not coming out correct?

Values not coming in few cell but coming in rest all cells

Totals not coming out correct.

Date Not coming into my XML file correct

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions