Lookup functions not working

  • Thread starter Thread starter Andrew Mueller
  • Start date Start date
A

Andrew Mueller

I'm attempting to get a lookup function to work and am having a tough
time with it. I have two calculated values in A1 (Ia/P) and B1 (Tc) that
I need to use to look up a third value (Peak) from a table (PEAK) on a
another worksheet. Here's part of the table:

PEAK
Ia 0.1 0.2 0.3……..
0.10 1010 910 800
0.11 1000 900 700
0.12 990 890 600
0.13 980 880 500
0.14 970 870 400
0.15 960 860 300
..
..
I'm using the following formula within an ISERROR function:
VLOOKUP(A1,PEAK, MATCH(B1,OFFSET(PEAK,1,,1,),FALSE),FALSE)

I have a similar lookup using a different table looking up text values.
Can anyone offer some help as to why I'm not able to get this to work?

Thanks for your help.

Andy Mueller
 
Paul,
Thanks for the help but unfortunately that didn't do the trick, I still get
the #NA error. The weird part is I have another lookup setup the same way as
my original post for a different table that works fine. Any other suggestions?
 
Andrew,

The other issue that comes to mind may be that you are looking up a
calculated value, which may not EXACTLY match the values in the table as the
FALSE option requires.

Try adding ROUND(A1,2) and see if that works.

PC
 
Andrew,

I should have said this in my last message, #NA in a lookup indicates the
lookup value is not found.

PC
 
Or, since the values in the first row and column are sorted, you could try
removing both FALSE's.
 
Back
Top