View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
candycasey
 
Posts: n/a
Default How can I bring forward formats with Vlookup?

when i use VLookUp, i get the data from the cell in another workbook - but
how do i get the formats? is there a numerical equivalent to shades of color
in the cells so i can generate a number in one book, bring the number into
the other, and turn it back to a color shade in the cell?