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
|