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!

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!

Tried the help first, not getting an answer.

Thanks for your response.



"Don Guillett" wrote:


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!

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


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Niki" wrote in message
...
Tried the help first, not getting an answer.

Thanks for your response.



"Don Guillett" wrote:


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!

Still coming up as invalid. Thanks for your responses.

Niki

"Niki" wrote:

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!

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



--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Niki" wrote in message
...
Still coming up as invalid. Thanks for your responses.

Niki

"Niki" wrote:

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!

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

"Don Guillett" wrote:

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



--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Niki" wrote in message
...
Still coming up as invalid. Thanks for your responses.

Niki

"Niki" wrote:

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!