Wondering if there is a way?
Thanks in advance for whomever looks at this. Here is my
problem. I have two Excel spreadsheets within a book. On
one sheet is a listing of customers and the corresponding
states they reside in. The second sheet is a price quote
sheet. Is there anyway I can reference the cell in the
price quote sheet which has a state value in it to lookup
and match the listing of customers with this value?
Thanks again!
|