Good Afternoon,
I have a Vlookup question that may be very simple.

I have a named range "PriceList" as below:
A B C
Product Code Description Price
101 Chicken Lips $1.19
102 Choice Chicken Lips $1.99
107 Chicken Feet $1.12
108 Select Chicken Feet $1.60
109 Choice Chicken Feet $1.99
115 Chicken Knuckles $4.19
120 Chicken Wing Tips $0.19
121 Chicken Eyelids, Upper $5.19
123 Chicken Eyelids, Lower $17.19

I want a formula to return my message :"Product Code does not exist" if I
type in say, "103" as my Lookup Value instead of "#NA".
I want it to reflect the EXACT match of product code or my own error
message.

Thanks,
Mike Meyer