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!