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