Lookup functions not working

[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 Corrado]

Andrew,

VLOOKUP(A1,PEAK, MATCH(B1,OFFSET(PEAK,0,0,1,),FALSE),FALSE)

HTH

PC

 

[Andrew 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?

 

[Paul Corrado]

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

 

[Paul Corrado]

Andrew,

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

PC

 

[Stephen Dunn]

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