Hi
though it makes no sense in your example case try
=IF(HLOOKUP(D1,A1:A3,3,0)0,HLOOKUP(D1,A1:A3,3,0), HLOOKUP(D1,A1:A3,2,0)
)

But still hwy not use
=IF(A30,A3,A2)



--
Regards
Frank Kabel
Frankfurt, Germany


Ronbo wrote:
Sorry about the first request, not being complete or
correct. A second try.

I am trying to create a formula that combines IF with
HLOOKUP. Example.
Cell a1 = 1, a2=10, a3=20; b1=2, b2 =12, b3=0 and so on
in row A. In D1 I have 1 in D2 I have the formula =IF
(HLOOKUP(D1,A1:A3,3)=0,(HLOOKUP(D1,A1:A3,3,(HLOOK UP
(D1,A1:A3,2))))). What I want the formula to do is
return the value in a3 if it is larger than 0 otherwise
return the value in a2. The problem I am having is that
it works fine if cell a3 is 0, but if cell a3 is 0 or
empty it returns 0 rather than 10.

Help is always appreciated.