Wondering if there is a way?
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
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)),"N o 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
customer) or don't mind seeing #N/A errors you can just
use the vlookup part.
.
|