Quatro to Excel formula

  • Thread starter Thread starter Niki
  • Start date Start date
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!
 
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))
 
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))
 
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
 
Back
Top