Combo box corrupting VLookup function
I changed several drop-down lists on an Excel worksheet to a Combo boxes so
that I could read the text. Several of these drop-down lists filled in other information through equations like: =IF(ISNA(VLOOKUP(C26,Lists!$L:$M,2,0))," ",VLOOKUP(C26,Lists!$L:$M,2,0)). Now, one drop down list will not function without correcting the error: Number Stored as Text. I have to convert to number for the vlookup to run every time I choose a new number. Please help, |
Combo box corrupting VLookup function
Hi,
Not sure fi this will help but try this: =IF(ISNA(VLOOKUP(C26*1,Lists!$L:$M,2,0)),"",VLOOKU P(C26*1,Lists!$L:$M,2,0)) it should convert C26 to a number. HTH Jean-Guy "lia" wrote: I changed several drop-down lists on an Excel worksheet to a Combo boxes so that I could read the text. Several of these drop-down lists filled in other information through equations like: =IF(ISNA(VLOOKUP(C26,Lists!$L:$M,2,0))," ",VLOOKUP(C26,Lists!$L:$M,2,0)). Now, one drop down list will not function without correcting the error: Number Stored as Text. I have to convert to number for the vlookup to run every time I choose a new number. Please help, |
All times are GMT +1. The time now is 05:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com