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)

--
Message posted via http://www.officekb.com

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" <u59737@uwe wrote in message
news:a7dca91adf1f6@uwe...
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)

--
Message posted via http://www.officekb.com

I will try it thanks for you help

p45cal wrote:
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
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)

--
Message posted via 'MS Office forums. More than 400,000 of Word, Excel
Outlook, PowerPoint, Publisher, InfoPath discussions.
(http://www.officekb.com)


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201005/1

Thanks for the suggestion I will try this one as well

L. Howard Kittle wrote:
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

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)

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201005/1