Excel 2007 : This or that formula depending on if the cell does show information or not.

[Saber]

Hi NVBC,

if i want to make a formula that says: if this cell is populated then use this formula =IF('BW DOWNLOAD'!K35<>"";'BW DOWNLOAD'!K35;IF('BW DOWNLOAD'!K34<>"";'BW DOWNLOAD'!K34;"")) and is the cell is does not show anything then use this Vlookup formula, how do i do. Note that all cells have a formula in them but not all of the cells does show any info.

Thank you very much.

Saber

[wmfinance]

Try =IF(A1=0,insert Vlookup formula,IF('BW DOWNLOAD'!K35<>"";'BW DOWNLOAD'!K35;IF('BW DOWNLOAD'!K34<>"";'BW DOWNLOAD'!K34;"")))

Here I am assuming that A1 is where you are starting, and that you have a vlookup formula that already works (but hasn't been posted).

If a cell is empty it is essentially reading 0, so that is how the logical portion of my equation works.

Hope this helps!