USING LOOKUP

estellita

New Member
Joined
Jan 26, 2005
Messages
1
Why is it, when using the Lookup function with an array, I get a #N/A result when the lookup value to be looked up is exactly the same as one of the values in the Lookup Table?

:confused:
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

lynxbci

Board Regular
Joined
Sep 22, 2004
Messages
201
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
could be vlues vs text issue, are they actually the same, ie both figures or both text!

try vlookup(value(A1),a:b,3) etc
 

rs2k

Well-known Member
Joined
Aug 15, 2004
Messages
1,413
Welcome to the board,
Can you post your formula and what you expect to return.

Colin.
 

steallan

Active Member
Joined
Oct 20, 2004
Messages
304
check that the values are the same, leading and trailing spaces often are a problem
 

yee388

Well-known Member
Joined
Mar 7, 2004
Messages
1,374
Your data might:

1) be usorted
2) have differing number formats (i.e. numbers might be stored as text in one of the two places)
3) have leading or trailing spaces, as often happens with data imports.

If none of those are the case, try posting a portion of your spreadsheet using Colo's HTML Maker (link at the bottom of the page)
 

Forum statistics

Threads
1,148,272
Messages
5,745,791
Members
423,973
Latest member
man_this_is_hard

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top