| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Still looking to be rid of the #N/A on look up table
I am not good at this at all, novice at best. This is my current formula,
are you able to tell me how to alter my formula to yield a - or 0? I appreciate your help =VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE) |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Still looking to be rid of the #N/A on look up table
=IF(ISERROR(VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE) ),"-",VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE))
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "smiley61799" wrote: I am not good at this at all, novice at best. This is my current formula, are you able to tell me how to alter my formula to yield a - or 0? I appreciate your help =VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE) |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Still looking to be rid of the #N/A on look up table
First of all.................your lookup value cannot be a range of cells so
you must re-write the original formula. =VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE) Now to get rid of the #N/A =IF(ISNA(VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE))," ",VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE)) Copy down as far as you need. Gord Dibben MS Excel MVP On Mon, 20 Apr 2009 10:58:04 -0700, smiley61799 wrote: I am not good at this at all, novice at best. This is my current formula, are you able to tell me how to alter my formula to yield a - or 0? I appreciate your help =VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE) |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Still looking to be rid of the #N/A on look up table
Thank you soooooo very much. This helped me out a great deal. It worked
beautifully! "Gord Dibben" wrote: First of all.................your lookup value cannot be a range of cells so you must re-write the original formula. =VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE) Now to get rid of the #N/A =IF(ISNA(VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE))," ",VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE)) Copy down as far as you need. Gord Dibben MS Excel MVP On Mon, 20 Apr 2009 10:58:04 -0700, smiley61799 wrote: I am not good at this at all, novice at best. This is my current formula, are you able to tell me how to alter my formula to yield a - or 0? I appreciate your help =VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE) |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Still looking to be rid of the #N/A on look up table
Hi
I've been searching through posts on various websites to try & help me get rid of #N/A within a formula to no avail. Can you please help??? My formula is =VLOOKUP(A9,'datasheet'!B3:BU29,3,'datasheet'!D3:D 29) & I have tried suggestions with IF(ISNA & IF(ISERROR but nothing seems to work - unless the my 2 conditions in the VLOOKUP are found - help!! -- CMB BT "smiley61799" wrote: Thank you soooooo very much. This helped me out a great deal. It worked beautifully! "Gord Dibben" wrote: First of all.................your lookup value cannot be a range of cells so you must re-write the original formula. =VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE) Now to get rid of the #N/A =IF(ISNA(VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE))," ",VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE)) Copy down as far as you need. Gord Dibben MS Excel MVP On Mon, 20 Apr 2009 10:58:04 -0700, smiley61799 wrote: I am not good at this at all, novice at best. This is my current formula, are you able to tell me how to alter my formula to yield a - or 0? I appreciate your help =VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE) |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Still looking to be rid of the #N/A on look up table
=if(isna(vlookup(a9,datasheet!b3:bu29,3,false)),"n o match",
vlookup(a9,datasheet!b3:bu29,3,false)) I used False as the last (4th) parameter in the =vlookup() function. That means I want an exact match to A9.) Claire wrote: Hi I've been searching through posts on various websites to try & help me get rid of #N/A within a formula to no avail. Can you please help??? My formula is =VLOOKUP(A9,'datasheet'!B3:BU29,3,'datasheet'!D3:D 29) & I have tried suggestions with IF(ISNA & IF(ISERROR but nothing seems to work - unless the my 2 conditions in the VLOOKUP are found - help!! -- CMB BT "smiley61799" wrote: Thank you soooooo very much. This helped me out a great deal. It worked beautifully! "Gord Dibben" wrote: First of all.................your lookup value cannot be a range of cells so you must re-write the original formula. =VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE) Now to get rid of the #N/A =IF(ISNA(VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE))," ",VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE)) Copy down as far as you need. Gord Dibben MS Excel MVP On Mon, 20 Apr 2009 10:58:04 -0700, smiley61799 wrote: I am not good at this at all, novice at best. This is my current formula, are you able to tell me how to alter my formula to yield a - or 0? I appreciate your help =VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE) -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Still looking to be rid of the #N/A on look up table
ps.
If I only needed to look at 3 columns (B:D) in the datasheet, I'd adjust the formula: =if(isna(vlookup(a9,datasheet!b3:d29,3,false)),"no match", vlookup(a9,datasheet!b3:d29,3,false)) Dave Peterson wrote: =if(isna(vlookup(a9,datasheet!b3:bu29,3,false)),"n o match", vlookup(a9,datasheet!b3:bu29,3,false)) I used False as the last (4th) parameter in the =vlookup() function. That means I want an exact match to A9.) Claire wrote: Hi I've been searching through posts on various websites to try & help me get rid of #N/A within a formula to no avail. Can you please help??? My formula is =VLOOKUP(A9,'datasheet'!B3:BU29,3,'datasheet'!D3:D 29) & I have tried suggestions with IF(ISNA & IF(ISERROR but nothing seems to work - unless the my 2 conditions in the VLOOKUP are found - help!! -- CMB BT "smiley61799" wrote: Thank you soooooo very much. This helped me out a great deal. It worked beautifully! "Gord Dibben" wrote: First of all.................your lookup value cannot be a range of cells so you must re-write the original formula. =VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE) Now to get rid of the #N/A =IF(ISNA(VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE))," ",VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE)) Copy down as far as you need. Gord Dibben MS Excel MVP On Mon, 20 Apr 2009 10:58:04 -0700, smiley61799 wrote: I am not good at this at all, novice at best. This is my current formula, are you able to tell me how to alter my formula to yield a - or 0? I appreciate your help =VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE) -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Still looking to be rid of the #N/A on look up table
Thank you Soooo much Dave - your a life saver!
-- CMB BT "Dave Peterson" wrote: ps. If I only needed to look at 3 columns (B:D) in the datasheet, I'd adjust the formula: =if(isna(vlookup(a9,datasheet!b3:d29,3,false)),"no match", vlookup(a9,datasheet!b3:d29,3,false)) Dave Peterson wrote: =if(isna(vlookup(a9,datasheet!b3:bu29,3,false)),"n o match", vlookup(a9,datasheet!b3:bu29,3,false)) I used False as the last (4th) parameter in the =vlookup() function. That means I want an exact match to A9.) Claire wrote: Hi I've been searching through posts on various websites to try & help me get rid of #N/A within a formula to no avail. Can you please help??? My formula is =VLOOKUP(A9,'datasheet'!B3:BU29,3,'datasheet'!D3:D 29) & I have tried suggestions with IF(ISNA & IF(ISERROR but nothing seems to work - unless the my 2 conditions in the VLOOKUP are found - help!! -- CMB BT "smiley61799" wrote: Thank you soooooo very much. This helped me out a great deal. It worked beautifully! "Gord Dibben" wrote: First of all.................your lookup value cannot be a range of cells so you must re-write the original formula. =VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE) Now to get rid of the #N/A =IF(ISNA(VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE))," ",VLOOKUP(F12,Sheet3!$G$4:$H$51,2,FALSE)) Copy down as far as you need. Gord Dibben MS Excel MVP On Mon, 20 Apr 2009 10:58:04 -0700, smiley61799 wrote: I am not good at this at all, novice at best. This is my current formula, are you able to tell me how to alter my formula to yield a - or 0? I appreciate your help =VLOOKUP(F12:F45,Sheet3!G4:H51,2,FALSE) -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Macro specific table to generic table? | Excel Discussion (Misc queries) | |||
| Pivit table- cell on spread sheet referencing pivot table field | Charts and Charting in Excel | |||
| entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
| Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
| PIVOT TABLE - Summary Table into a Databasae Table. | Excel Worksheet Functions | |||
Linear Mode
