N
Neutron
Greetings ALL,
I need help
Column A is "Regions"
Column B is "Store #"
I need A1 to look at the value in B1, and then find that value i
another sheet (a list of stores and their region #'s), and then retur
the "region" value that is to the left of the "store" value.
Does this make sense? I've attached a small sample spreadsheet to hel
illustrate what I am look for.
Many thanks in advance.
Fran
Attachment filename: excel help.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54755
I need help
Column A is "Regions"
Column B is "Store #"
I need A1 to look at the value in B1, and then find that value i
another sheet (a list of stores and their region #'s), and then retur
the "region" value that is to the left of the "store" value.
Does this make sense? I've attached a small sample spreadsheet to hel
illustrate what I am look for.
Many thanks in advance.
Fran
Attachment filename: excel help.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=54755