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