VLOOKUP and formats

[601488]

Good afternoon,

I have a set of data in a spreadsheet as follows, for example:
A B
200571 Jim
200572 Barry
200573 Simon
200574 Alex

I then have a vlookup in another tab whereby I lookup from the six digit code and want to return the name in column B. However, I want to be able to return the format of that data too. For example if I'm looking up from 200573 I want to return Simon but in red text, whereas if I lookup 200571 I want to return Jim but in black text.

Any thoughts?

Thank you

​

 

[Fluff]

You cannot do that with a formula, as formulae do not see formats.

 

[aRandomHelper]

If Simon is conditionally formatted, then what you can try is to also Vlookup the conditions contributing to the formatting, then apply the same conditional formatting to the first Vlookup cell/column.