View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
opieandy opieandy is offline
external usenet poster
 
Posts: 32
Default Combo Box - How to Use Output in Vlookup

I've created a combo box and linked its output to a cell. I'm using that
cell in a vlookup formula. Using the combo box blows the vlookup formula.

The cell is formatted correctly (as a number), though the number doesn't
line up with the numbers below it (which aren't yet linked to a combo box),
and format painter does not change it to match those cells, so that tells me
there's something screwy about the format, but still not sure why vlookup
won't recognize it.

Any help/thoughts/ideas?

Thanks,

Chris