If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 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
|
|||
|
|||
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 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
|
|||
|
|||
Still looking to be rid of the #N/A on look up table
ps.
If I only needed to look at 3 columns (B) 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 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
|
|||
|
|||
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) 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 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 |
Thread Tools | |
Display Modes | |
|
|