Help me (Vlookup)

[Amin]

hi my problem here is that i get this #NA thing anytime i select a product
code more than twice.

data is formatted as tables in the lookup sheet with 757 rows.
my other sheet is just 5 rows but i have used data validation liminting the
entry to the codes. but i have realised that a few minutes a go that the #NA
keep coming up but when i choose a different code it gives me the the product
name.

if choose
lCQ 1
LCQ 2
LCQ 3 this gets me #NA
but as soon as that is changed i get a name
any reason for that please.

 

[Jacob Skaria]

I am not sure I understood your query correctly. If you want to handle #NA
then modify your formula as below...Replace the text with the current vlookup
formula

=IF(ISNA(yourvlookupformula),"",yourvlookupformula)

 

[Amin]

Hi there thank you so much for the reply but have a look if am doing
something wrong the formula is not accepted after i typed in this
=IF(ISNA(VLOOKUP(A2,'Inventory List'!O739,2,FALSE),"",VLOOKUP(A2,'Inventory
List'!O739,2,FALSE)

 

[Jacob Skaria]

Try the below...

'Inventory List'!O739 is not a valid array. Please edit to suit....

=IF(ISNA(VLOOKUP(A2,'Inventory List'!A1:O739,2,0)),"",
VLOOKUP(A2,'Inventory List'!A1:O739,2,0))

 

[Amin]

Hey dude my eye brows have raised here, can you then kinindly in your own
time explain to me why this i have done below happens including yor own
formular. thank you.
FORMULAR AND RESULTS:
=VLOOKUP(A2,'Inventory List'!A1:O739,2,FALSE)
LCQ-D Dreamer LCQ
LCQ-CHIC Chic LCQ
LCQ-FK French Kiss LCQ
LCQ-O Opulent LCQ
LCQ-T TRUE LCQ
LCQ-P Plush LCQ
LCQ-P Plush LCQ
LCQ-P Plush LCQ
LCQ-P Plush LCQ
LCQ-P #N/A
LCQ-P #N/A

FORMULAR AND RESULTS:
=VLOOKUP(A2,'Inventory List'!$A$1:$O$739,2,FALSE)
LCQ-D Dreamer LCQ
LCQ-CHIC Chic LCQ
LCQ-P Plush LCQ
LCQ-P Plush LCQ
LCQ-P Plush LCQ
LCQ-P Plush LCQ
LCQ-P Plush LCQ
LCQ-P Plush LCQ
LCQ-P Plush LCQ
LCQ-P Plush LCQ
LCQ-P Plush LCQ


FORMULAR AND RESULTS:
=IF(ISNA(VLOOKUP(A2,'Inventory List'!O739,2,FALSE),"",VLOOKUP(A2,'Inventory
List'!O739,2,FALSE)
LCQ-D Dreamer LCQ
LCQ-CHIC Chic LCQ
LCQ-FK French Kiss LCQ
LCQ-O Opulent LCQ
LCQ-T TRUE LCQ
LCQ-P Plush LCQ
LCQ-P Plush LCQ
LCQ-P Plush LCQ
LCQ-P Plush LCQ
LCQ-P
LCQ-P

Iwill be very grateful

 

[Jacob Skaria]

Check out the below by Debra on troubleshooting VLOOKUP()

http://contextures.com/xlFunctions02.html#Trouble

 

[L. Howard Kittle]

Perhaps try this, looks like you are missing a ) after each ...FALSE) in the
formula. Notice the ...FALSE)) in the formula below.

=IF(ISNA(VLOOKUP(A2,'Inventory List'!O739,2,FALSE)),"",VLOOKUP(A2,'Inventory
List'!O739,2,FALSE))

HTH
Regards,
Howard