Lookup Function

  • Thread starter Thread starter GREGPOOH43
  • Start date Start date
G

GREGPOOH43

I HAVE A LIST OF PART# AND DESCRIPTIONS ON SHEET 1
ON SHEET 2 WHEN I ENTER A CORRECT PART# IT GIVES ME THE DESCRIPTION
WHAT I WANT TO DO IS WHEN I ENTER A WRONG PART# I DONT WANT IT T
DEFAULT TO THE NEAREST PART #.
ANY HELP IS APPRECIATED

THANKS
GRE
 
Dear Greg

Try to use ISERROR to solve your problem.

=IF(ISERROR(VLOOKUP(A1,C1:D2,2,FALSE))=TRUE,"N/A",VLOOKUP(A1,C1:D2,2,FALSE))

Regards
JOHN
 
You can set VLOOKUP's range_lookup parameter to FALSE:


=VLOOKUP(A1,Sheet1!A:B,2,FALSE)

This will return "#N/A" when an incorrect part number is entered. To
return a different value:

=IF(ISNA(MATCH(A1,Sheet1!A:A,FALSE)),"Invalid Part Number",
VLOOKUP(A1,Sheet1!A:B,2,FALSE))
 
The Vlookup formulae should end with ,0
eg
=vlookup(d2, A:B,2,0

as of now you may be using ,false or ,1 etc..

all the best,
 
FALSE = 0 in this instance, and either can be used to specify an Exact Match
requirement
 
Back
Top