you could use MATCH() instead to return the row/column in the table, then
use a range object to get that cell's properties



"rickcstahl" wrote in message
...
I am using VLOOKUP to retrieve values from several different worksheets.
I
also wish to retreive the cell's format (color). There are many different
colors on the worsheets based on many complex criteria. Is there anyway
the
individual formats of the cells retrieved can also be returned with the
values ?

Thanks,
Rick