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!

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.

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.
.