Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables keep corrupting -- Office 12 beta | Excel Discussion (Misc queries) | |||
VB Corrupting Pivot Tables | Excel Discussion (Misc queries) | |||
vlookup from a combo box? | Excel Discussion (Misc queries) | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Vlookup from Combo Box | Excel Discussion (Misc queries) |