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

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

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)
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,972
Messages
5,767,393
Members
425,410
Latest member
SmittyT

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