Quatro to Excel formula
 

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!

Quatro to Excel formula
 

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!

Quatro to Excel formula
 

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!

Quatro to Excel formula
 

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!

Quatro to Excel formula
 

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!

Quatro to Excel formula
 

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!

Quatro to Excel formula
 

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!