Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I return the format & value of cell with VLOOKUP ?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I return the format & value of cell with VLOOKUP ?
Not with a formula
-- Don Guillett Microsoft MVP Excel SalesAid Software "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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I return the format & value of cell with VLOOKUP ?
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I return the format & value of cell with VLOOKUP ?
i hit send too early
i was suggesting that MATCH would allow you to do this example so instead of dim val as string val = WorksheetFunction.VLOOKUP(what, where, ret, false) dim val as Range dim rowindex as long rowindex = WorksheetFunction.MATCH(what, where.columns(1), false) set val = where.resize(1,1).Cells(index,ret) whe what is string to be found, where is the range table to be searched, ret is the return column "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup and Trace Return Cell | Excel Discussion (Misc queries) | |||
VLOOKUP to return Cell Address | Excel Worksheet Functions | |||
To return a blank cell rather than 0% in a vlookup. | Excel Worksheet Functions | |||
Vlookup to Return Cell Name Not Value? | Excel Programming | |||
Vlookup return NA for numbers format as general | Excel Worksheet Functions |