You might try looking in the help index for VLOOKUP.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Niki" wrote in message
...
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!