List help

[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

 

[Bob Umlas]

in A1:
=LOOKUP(B1,Sheet2!B1:B100,Sheet2!A1:A100)