<div>
Not a straight vlookup, but you can use a workaround or a user-defined function (= some kind of macro) to do that. <br />
Can you explain more in details what you want to do, preferably with a template file?<br />
<br />
Thanks,<br />
<br />
Thomas
</div>


<div>
Hi Nutsch,<br />
<br />
Essentially I have a large list of values and conditioning formatting within the cells determines what colour they are to be highlighted with i.e. 150 = red 200 = yellow etc. Essentially I would like a formula I can paste into a cell that can get first instance of cell highlighted in that colour. <br />
<br />
Thank you
</div>


<div>
That would be the same as looking for the first cell above 200, no?
</div>


<div>
Do you want to return the value of the cell or its location? What is the complete condition for the yellow cell?
</div>


<div>
If A1&gt;200 - Make Cell Yellow<br />
Return the Value.<br />

</div>


<div>
<div class="content wysiwyg-content">
Heyas,<br />
<br />
Is there any way to perform a VLOOKUP based on whether the cell has a yellow background or not.<br />
<br />
Thank you. 
</div>
</div>


Heyas,

Is there any way to perform a VLOOKUP based on whether the cell has a yellow background or not.

Thank you. 

Not a straight vlookup, but you can use a workaround or a user-defined function (= some kind of macro) to do that. 
Can you explain more in details what you want to do, preferably with a template file?

Thanks,

Thomas

Hi Nutsch,

Essentially I have a large list of values and conditioning formatting within the cells determines what colour they are to be highlighted with i.e. 150 = red 200 = yellow etc. Essentially I would like a formula I can paste into a cell that can get first instance of cell highlighted in that colour. 

Thank you

That would be the same as looking for the first cell above 200, no?

Do you want to return the value of the cell or its location? What is the complete condition for the yellow cell?

If A1&amp;gt;200 - Make Cell Yellow
Return the Value.


Excel VLOOKUP Question

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.