I am trying to create a formula that combines If with
Lookup. Example.
Cell a1=1, a2=10, a3=20. The formula that I have in d1
is, =IF(HLOOKUP(A1,A1:A3,3)=0,(HLOOKUP(A1,A1:A3,3,
(HLOOKUP(A1,A1:A3,2))))). What I want the formula to do
is a LOOKUP and then return the value in a3 if it is
larger than 0 otherwise return the value in a2.

Help is always appreciated.

First, HLookup is for horizontal lookup and you data is vertical

Second, you don't need to look up anything

=if(A30,A3,A2)

Should do what you describe.

--
Regards,
Tom Ogilvy


"Ronbo" wrote in message
...
I am trying to create a formula that combines If with
Lookup. Example.
Cell a1=1, a2=10, a3=20. The formula that I have in d1
is, =IF(HLOOKUP(A1,A1:A3,3)=0,(HLOOKUP(A1,A1:A3,3,
(HLOOKUP(A1,A1:A3,2))))). What I want the formula to do
is a LOOKUP and then return the value in a3 if it is
larger than 0 otherwise return the value in a2.

Help is always appreciated.
=

Hi
don't use VLOOKUP in this case. Try
=IF(A30,A3,A2)

--
Regards
Frank Kabel
Frankfurt, Germany


Ronbo wrote:
I am trying to create a formula that combines If with
Lookup. Example.
Cell a1=1, a2=10, a3=20. The formula that I have in d1
is, =IF(HLOOKUP(A1,A1:A3,3)=0,(HLOOKUP(A1,A1:A3,3,
(HLOOKUP(A1,A1:A3,2))))). What I want the formula to do
is a LOOKUP and then return the value in a3 if it is
larger than 0 otherwise return the value in a2.

Help is always appreciated.

-----Original Message-----
I am trying to create a formula that combines If with
Lookup. Example.
Cell a1=1, a2=10, a3=20. The formula that I have in d1
is, =IF(HLOOKUP(A1,A1:A3,3)=0,(HLOOKUP(A1,A1:A3,3,
(HLOOKUP(A1,A1:A3,2))))). What I want the formula to do
is a LOOKUP and then return the value in a3 if it is
larger than 0 otherwise return the value in a2.

Help is always appreciated.

.
I have to use HLOOKUP. The example in A1 is just one
cell.