Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exact lookup formulas, VB Instead?
I have a problem when using lookup formulas. I even updated the formula
recently using another formula I found. I use this formula to look up part #'s and return another associated number. It is VERY important that I get the right numbers however, it appears that these formulas always look up the closest match instead of the exact match. For example, if I look up part h006, and it is not listed, I need it to say just that specifically. First formula: Basic Lookup Formula Second formula: IF(ISNA(LOOKUP(x)),"PART # NOT LISTED",LOOKUP (x)) x (replaces search criteria) Can this be done in VB instead? This is a major project and I cant have bad lookups. thanx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Exact lookup formulas, VB Instead?
Use VLOOKUP.
For an exact match, the 4th argument of VLOOKUP() has to be FALSE -- Kind regards, Niek Otten Microsoft MVP - Excel "J.W. Aldridge" wrote in message ups.com... |I have a problem when using lookup formulas. I even updated the formula | recently using another formula I found. I use this formula to look up | part #'s and return another associated number. It is VERY important | that I get the right numbers however, it appears that these formulas | always look up the closest match instead of the exact match. For | example, if I look up part h006, and it is not listed, I need it to say | just that specifically. | | First formula: Basic Lookup Formula | Second formula: IF(ISNA(LOOKUP(x)),"PART # NOT LISTED",LOOKUP (x)) | | x (replaces search criteria) | | Can this be done in VB instead? | This is a major project and I cant have bad lookups. | thanx | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find exact value using LOOKUP | Excel Discussion (Misc queries) | |||
Lookup exact number | Excel Discussion (Misc queries) | |||
Need to do an EXACT LOOKUP | Excel Worksheet Functions | |||
LookUp - Exact only | Excel Worksheet Functions | |||
LookUp - Exact only | Excel Worksheet Functions |