vlookup lookup_value text
I have a very simple vlookup function that I am using to pull data from
another worksheet. The problem I'm having is that the text I'm referencing as the lookup_value contains a quotation mark ... 18" Bead Diameter. So, if I key it in as "18" Bead Diameter" of course it gives me an error. The correction Excel suggests is "18""BeadDiameter" which is not correct. Can't figure out how many quotation marks I need and where to put them to make this work. Thanks in advance!! |
vlookup lookup_value text
18" Bead Diameter
Excel suggests is "18""BeadDiameter" Excel's suggestion has removed the spaces. That will work, just add the spaces: =VLOOKUP("18"" Bead Diameter",F1:G10,2,0) Better yet, use a cell to hold the lookup value: A1 = 18" Bead Diameter Then: =VLOOKUP(A1,F1:G10,2,0) -- Biff Microsoft Excel MVP "natk" wrote in message ... I have a very simple vlookup function that I am using to pull data from another worksheet. The problem I'm having is that the text I'm referencing as the lookup_value contains a quotation mark ... 18" Bead Diameter. So, if I key it in as "18" Bead Diameter" of course it gives me an error. The correction Excel suggests is "18""BeadDiameter" which is not correct. Can't figure out how many quotation marks I need and where to put them to make this work. Thanks in advance!! |
vlookup lookup_value text
Ok... got it. I knew it was taking out spaces, but wasn't sure how to
account for the spaces that did belong. How about this one? 43" - 45" ... I know it would be better to just reference a cell containing this, but I can't alter the structure of the worksheet b/c someone else's sheets are fed from it and I don't want to cause them grief in having to change their format/formulas. : p Thanks!! "T. Valko" wrote: 18" Bead Diameter Excel suggests is "18""BeadDiameter" Excel's suggestion has removed the spaces. That will work, just add the spaces: =VLOOKUP("18"" Bead Diameter",F1:G10,2,0) Better yet, use a cell to hold the lookup value: A1 = 18" Bead Diameter Then: =VLOOKUP(A1,F1:G10,2,0) -- Biff Microsoft Excel MVP "natk" wrote in message ... I have a very simple vlookup function that I am using to pull data from another worksheet. The problem I'm having is that the text I'm referencing as the lookup_value contains a quotation mark ... 18" Bead Diameter. So, if I key it in as "18" Bead Diameter" of course it gives me an error. The correction Excel suggests is "18""BeadDiameter" which is not correct. Can't figure out how many quotation marks I need and where to put them to make this work. Thanks in advance!! |
vlookup lookup_value text
How about this one? 43" - 45" ...
=VLOOKUP("43"" - 45""",F1:G10,2,0) -- Biff Microsoft Excel MVP "natk" wrote in message ... Ok... got it. I knew it was taking out spaces, but wasn't sure how to account for the spaces that did belong. How about this one? 43" - 45" ... I know it would be better to just reference a cell containing this, but I can't alter the structure of the worksheet b/c someone else's sheets are fed from it and I don't want to cause them grief in having to change their format/formulas. : p Thanks!! "T. Valko" wrote: 18" Bead Diameter Excel suggests is "18""BeadDiameter" Excel's suggestion has removed the spaces. That will work, just add the spaces: =VLOOKUP("18"" Bead Diameter",F1:G10,2,0) Better yet, use a cell to hold the lookup value: A1 = 18" Bead Diameter Then: =VLOOKUP(A1,F1:G10,2,0) -- Biff Microsoft Excel MVP "natk" wrote in message ... I have a very simple vlookup function that I am using to pull data from another worksheet. The problem I'm having is that the text I'm referencing as the lookup_value contains a quotation mark ... 18" Bead Diameter. So, if I key it in as "18" Bead Diameter" of course it gives me an error. The correction Excel suggests is "18""BeadDiameter" which is not correct. Can't figure out how many quotation marks I need and where to put them to make this work. Thanks in advance!! |
All times are GMT +1. The time now is 10:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com