Vlookup
in [General]
|
From: Cerealkiller via OfficeKB.com on 11 May 2010 17:24 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
From: p45cal on 11 May 2010 18:15 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) ? C e r e a l k i l l e r v i a O f f i c e K B . c o m ; 7 2 1 6 6 2 W r o t e : > 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 'MS Office forums. More than 400,000 of Word, Excel, Outlook, PowerPoint, Publisher, InfoPath discussions.' (http://www.officekb.com) -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=202086 http://www.thecodecage.com/forumz
From: L. Howard Kittle on 11 May 2010 18:22 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(a)uwe> wrote in message news:a7dca91adf1f6(a)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 >
From: Cerealkiller via OfficeKB.com on 12 May 2010 00:26 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.aspx/ms-excel/201005/1
From: Cerealkiller via OfficeKB.com on 12 May 2010 00:27 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.aspx/ms-excel/201005/1
|
Pages: 1 Prev: Why does row one always appear at the top when page down Next: Create Range from Range |