Need formula

[Sandy]

I have the following formula in column J:
=IF(ISNA(VLOOKUP($A7,downlink!$A$2:$H$200,4,FALSE))
=TRUE,0,VLOOKUP($A7,downlink!$A$2:$H$200,4,FALSE))

I need a formula that checks whether column K has a value
in it. If so, use the value in K; if K is null, use the
above formula in J.

Any help will be appreciated!

 

[Norman Harker]

Hi Sandy!

I think that this is what you are looking for:

=IF(ISBLANK(K7),IF(ISNA(VLOOKUP($A7,downlink!$A$2:$H$200,4,FALSE)),0,V
LOOKUP($A7,downlink!$A$2:$H$200,4,FALSE)),K7)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Monday 14th July: France, French Guinea,
French Polynesia, Guadeloupe, New Caledonia, St Martin, and St. Pierre
& Miquelon (Bastille Day); Martinique and Mayotte (National Days);
Madagascar (Fandoana Bathing Festival); Sweden (Crown Princess'
Birthday);Turkmenistan (Turkment Bakhsi Holiday); United Kingdom
(Emmeline Pankhurst Day). O-Bon / Festival of Souls (Shinto). NYT of
14-Jul-2003 reports Iraq National Day as cancelled public holiday.
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Sandy]

Thanks Norman!

-----Original Message-----
Hi Sandy!

I think that this is what you are looking for:

=IF(ISBLANK(K7),IF(ISNA(VLOOKUP($A7,downlink! $A$2:$H$200,4,FALSE)),0,V
LOOKUP($A7,downlink!$A$2:$H$200,4,FALSE)),K7)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Monday 14th July: France, French Guinea,
French Polynesia, Guadeloupe, New Caledonia, St Martin, and St. Pierre
& Miquelon (Bastille Day); Martinique and Mayotte (National Days);
Madagascar (Fandoana Bathing Festival); Sweden (Crown Princess'
Birthday);Turkmenistan (Turkment Bakhsi Holiday); United Kingdom
(Emmeline Pankhurst Day). O-Bon / Festival of Souls (Shinto). NYT of
14-Jul-2003 reports Iraq National Day as cancelled public holiday.
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.