New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

VLOOKUP returning #N/A

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

VLOOKUP returning #N/A

Postby gijenjen » Fri Dec 16, 2016 11:27 am

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

Postby gebobs » Mon Dec 19, 2016 12:32 pm

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

Postby gebobs » Mon Dec 19, 2016 12:41 pm

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

Postby AllenimIptWP » Tue Dec 20, 2016 2:27 pm

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

Postby ConneXionLost » Tue Dec 20, 2016 5:16 pm

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
Location: Canada
Reputation: 19
Excel Version: 2003, 2010


Return to General Excel Questions

Who is online

Users browsing this forum: Google [Bot] and 20 guests