Quatro to Excel formula

[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!

 

[Don Guillett]

You might try looking in the help index for VLOOKUP.

 

[Niki]

Tried the help first, not getting an answer.

Thanks for your response.

 

[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))

 

[Niki]

Still coming up as invalid. Thanks for your responses.

Niki

 

[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))

 

[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