# Premium Excel Course Now Available!

## VLOOKUP returning #N/A

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at TeachExcel.com.

### VLOOKUP returning #N/A

Both of the below formulas keep returning me a #N/A

=INDEX('convert cost code table'!A1:A248,MATCH(Report1!A13,'convert cost code table'!B1:B248,0))
=VLOOKUP(A13,'convert cost code table'!B2:B500,2,TRUE)

I am tell it to look at the cell A13, go to the other sheet (convert cost code table) look through the list and when it matches, give me the answer in the column next to it.
What am I doing wrong?

numbers in A13 are set up like this 90-010-0 is using information like this that isn't really a number, an issue?
• 0

gijenjen
Rookie

Posts: 1
Joined: Dec 16, 2016
Reputation: 0
Excel Version: 2013

### Re: VLOOKUP returning #N/A

Could you attach a sample of your sheet?
• 0

gebobs
Regular

Posts: 74
Joined: Feb 23, 2015
Reputation: 9
Excel Version: 2010

### Re: VLOOKUP returning #N/A

One thing though...if you are using an approximate match (range_lookup = TRUE), the table must be sorted
• 0

gebobs
Regular

Posts: 74
Joined: Feb 23, 2015
Reputation: 9
Excel Version: 2010

### VLOOKUP returning #N/A

Hi,

I see that you are trying to derive the results by calling the WorksheetFunction object rather than by using formulas in the worksheet. Is using the worksheet to calculate the results unacceptable and, if so, why?
• 0

AllenimIptWP
Rookie

Posts: 1
Joined: Dec 16, 2016
Location: Papua New Guinea
Reputation: 0
Excel Version: 2007

### Re: VLOOKUP returning #N/A

The table array you designated is only one column wide (col B), but you are asking the VLOOKUP function to return data from the second array column.
• 1

ConneXionLost
Regular

Posts: 68
Joined: May 9, 2013