Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Question
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP Question | Excel Discussion (Misc queries) | |||
vlookup question | Excel Discussion (Misc queries) | |||
Vlookup question | Excel Discussion (Misc queries) | |||
Vlookup question | Excel Worksheet Functions | |||
vlookup question please | Excel Worksheet Functions |