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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

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
305
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,182,194
Messages
5,934,195
Members
436,935
Latest member
Fergjosh97

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