Help me (Vlookup)
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" wrote:
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 )
--
Jacob (MVP - Excel)
"Amin" wrote:
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.
|