ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Exact lookup formulas, VB Instead? (https://www.excelbanter.com/excel-programming/371028-exact-lookup-formulas-vbulletin-instead.html)

J.W. Aldridge

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


Niek Otten

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
|




All times are GMT +1. The time now is 09:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com