| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help me (Vlookup)
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help me (Vlookup)
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help me (Vlookup)
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)) -- Jacob (MVP - Excel) "Amin" wrote: 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help me (Vlookup)
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" wrote: 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)) -- Jacob (MVP - Excel) "Amin" wrote: 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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help me (Vlookup)
Check out the below by Debra on troubleshooting VLOOKUP()
http://contextures.com/xlFunctions02.html#Trouble -- Jacob (MVP - Excel) "Amin" wrote: 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" wrote: 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)) -- Jacob (MVP - Excel) "Amin" wrote: 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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help me (Vlookup)
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 "Amin" wrote in message ... 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" wrote: 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)) -- Jacob (MVP - Excel) "Amin" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If (Vlookup 0) working, but what if Vlookup cell does not exist | Excel Worksheet Functions | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Linear Mode
