Vlookup

[Cerealkiller via OfficeKB.com]

I am using excel 2000 I am trying to use two columns to make the end result
have a number in it
I am not sure how to word it but I need S2 and R2 to reference the vlookup
chart and give me the number that corresponds with it

=vlookup(S2,R2,$H$1:$M$4,3,false)

 

[p45cal]

perhaps:
=VLOOKUP(S2,$H$1:$M$4,3,FALSE)
VLOOKUP(R2,$H$1:$M$4,3,FALSE)

or:
=VALUE(VLOOKUP(S2,$H$1:$M$4,3,FALSE)
VLOOKUP(R2,$H$1:$M$4,3,FALSE))

?

On second thoughts, perhaps:
=VALUE(VLOOKUP(S2 & R2,$H$1:$M$4,3,FALSE)


?



I am using excel 2000 I am trying to use two columns to make the en
result

have a number in it
I am not sure how to word it but I need S2 and R2 to reference th vlookup
chart and give me the number that corresponds with it

=vlookup(S2,R2,$H$1:$M$4,3,false)

Outlook, PowerPoint, Publisher, InfoPath discussions.
(http://www.officekb.com)

 

[L. Howard Kittle]

Try one of these.


=VLOOKUP(--(A1&B1),$E$1:$F$30,2,0)

Where A1 = 1 and B1 = 2 and a lookup value in column E is 12.

=VLOOKUP(A1&B1,$E$1:$F$30,2,0)

Where A1 = one and B1 = two and a lookup value in column E is onetwo.

HTH
Regards,
Howard

 

[Cerealkiller via OfficeKB.com]

I will try it thanks for you help

perhaps:
=VLOOKUP(S2,$H$1:$M$4,3,FALSE)
VLOOKUP(R2,$H$1:$M$4,3,FALSE)

or:
=VALUE(VLOOKUP(S2,$H$1:$M$4,3,FALSE)
VLOOKUP(R2,$H$1:$M$4,3,FALSE))

?

On second thoughts, perhaps:
=VALUE(VLOOKUP(S2 & R2,$H$1:$M$4,3,FALSE)

?

Cerealkiller via OfficeKB.com;721662 Wrote:

I am using excel 2000 I am trying to use two columns to make the en
result
Outlook, PowerPoint, Publisher, InfoPath discussions.
(http://www.officekb.com)

 

[Cerealkiller via OfficeKB.com]

Thanks for the suggestion I will try this one as well