Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup formula
Hi...really need some help here...On 1 sheet i have 3 columns..Column
A is Region, Column B, Store Number, Column C is Store Name...on a another sheet, I have the Store numbers and store name...how do i create a Vlookup so it looks at the store and populate for me the Region the store belongs to??Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup formula
=INDEX(Sheet!$A$2:$A$100,MATCH($A2,Sheet1!$B$2:$B$ 100),0)
A2 in sheet2 contains the Store Number Copy formula down if you have list of stores in A3 onwards "Gor_yee" wrote: Hi...really need some help here...On 1 sheet i have 3 columns..Column A is Region, Column B, Store Number, Column C is Store Name...on a another sheet, I have the Store numbers and store name...how do i create a Vlookup so it looks at the store and populate for me the Region the store belongs to??Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup formula
Try this
=INDEX(A:A,MATCH(Sheet2!D1,B:B,0)) Lookup value in sheet2 D1 Store numbers in col B Regions in Col A Mike "Gor_yee" wrote: Hi...really need some help here...On 1 sheet i have 3 columns..Column A is Region, Column B, Store Number, Column C is Store Name...on a another sheet, I have the Store numbers and store name...how do i create a Vlookup so it looks at the store and populate for me the Region the store belongs to??Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup formula
To use VLOOKUP the item you are searching for must be in the left-most
column of the lookup table. You will need to use an INDEX(MATCH()) combination if this is not the case, so have a look in XL Help. Hope this helps. Pete On Jun 27, 1:52 pm, Gor_yee wrote: Hi...really need some help here...On 1 sheet i have 3 columns..Column A is Region, Column B, Store Number, Column C is Store Name...on a another sheet, I have the Store numbers and store name...how do i create a Vlookup so it looks at the store and populate for me the Region the store belongs to??Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) | |||
Using a Vlookup within an IF formula | Excel Discussion (Misc queries) | |||
HELP!!! VLOOKUP Formula Help | Excel Discussion (Misc queries) | |||
a possible vlookup formula....help | Excel Discussion (Misc queries) | |||
Help with vlookup formula | Excel Worksheet Functions |