Wondering if there is a way?

D

dregan

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!
 
M

Marcotte A

I'm assuming there is only one price per state, and you want the price to appear next to the customers name (on the first sheet.

Try
=IF(ISNA(VLOOKUP(B5,Sheet2!$A$1:$B$6,2,FALSE)),"No Price",(VLOOKUP(B5,Sheet2!$A$1:$B$6,2,FALSE))
Where
B5 is the customer's stat
Sheet2!$A$1:$B$6 is the state/price matri

If you have prices for every state (and states for every customer) or don't mind seeing #N/A errors you can just use the vlookup part.
 
D

dregan

I am actually not trying to get a price. I am trying to
get a list of customers within the matching state. Would
the below statement work? Thanks again!
-----Original Message-----
I'm assuming there is only one price per state, and you
Click to expand...
want the price to appear next to the customers name (on
the first sheet.)
Try:
=IF(ISNA(VLOOKUP(B5,Sheet2!$A$1:$B$6,2,FALSE)),"No Price", (VLOOKUP(B5,Sheet2!$A$1:$B$6,2,FALSE)))
Where
B5 is the customer's state
Sheet2!$A$1:$B$6 is the state/price matrix

If you have prices for every state (and states for every
Click to expand...
customer) or don't mind seeing #N/A errors you can just
use the vlookup part.
 
Top