Quatro to Excel formula

N

Niki

I have a Quatropro formula @IF@VLOOKUP($B23,$Sheet2:$B$5..$R$94,D$1,1)<1,"
",@VLOOKUP($B23,$Sheet2:$B$5..$R$94,D$1,1)) which pulls the last value in a
column from a sheet to a summary spreadsheet, I have been unable to find an
equivalent Excel formula.

Any suggestions, Thank you!
 
D

Don Guillett

try this one line formula
=IF(VLOOKUP($B23,Sheet2!$B$5:$R$94,D$1,0)<1,"",VLOOKUP($B23,Sheet2!$B$5:$R$94,D$1,1))
 
D

Don Guillett

Change to
=IF(VLOOKUP($B23,Sheet2!$B$5:$R$94,D$1,0)<1,"",VLOOKUP($B23,Sheet2!$B$5:$R$94,D$1,1,0))
 
N

Niki

Thanks again Don, I'm still plugging along with this spreadsheet. With your
help I've been able to get this formula to work in some cells but not all.

Niki
 
Top