ExcelBanter - Vlookup

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup (https://www.excelbanter.com/excel-worksheet-functions/215950-vlookup.html)

Hi,

Is it possible to look up not only the contents of a cell, but also the cell
color using a vlookup?

Thanks,

No, not using VLOOKUP.

Pete

On Jan 9, 4:58*pm, Richard wrote:
Hi,

Is it possible to look up not only the contents of a cell, but also the cell
color using a vlookup?

Thanks,

Is there another methos?

"Pete_UK" wrote:

No, not using VLOOKUP.

Pete

On Jan 9, 4:58 pm, Richard wrote:
Hi,

Is it possible to look up not only the contents of a cell, but also the cell
color using a vlookup?

Thanks,

Functions within Excel can do nothing about formatting, but you can
use VBA to get colours.

Bob Phillips gives details of a User-defined function he

http://www.xldynamic.com/source/xld.ColourCounter.html

which can return the colour of a cell. Perhaps you can incorporate
this into your workbook.

Hope this helps.

Pete

On Jan 9, 5:28*pm, Richard wrote:
Is there another methos?

"Pete_UK" wrote:
No, not using VLOOKUP.

Pete

On Jan 9, 4:58 pm, Richard wrote:
Hi,

Is it possible to look up not only the contents of a cell, but also the cell
color using a vlookup?

Thanks,- Hide quoted text -

- Show quoted text -