|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 11th, 2010, 10:24 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
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 
|
|
#2
May 11th, 2010, 11:22 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup
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
|
|
#3
May 12th, 2010, 05:26 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup
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
|
|
#4
May 12th, 2010, 05:27 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Vlookup
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
