USING LOOKUP

[estellita]

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?

 

[lynxbci]

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]

Welcome to the board,
Can you post your formula and what you expect to return.

Colin.

 

[steallan]

check that the values are the same, leading and trailing spaces often are a problem

 

[yee388]

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)