HLookup, Match, something?


I’m working in Excel, trying to find a solution to a problem. I’ll try to explain. I have a ditty of a script that when a cell is clicked on it cycles through a range of 5 colours, on the same row that the cell is clicked on is some data, I can retrieve this data in VBA ok, on another sheet is the same data. I want to colour a cell 2 rows up from where the cell matches the one on the first page.

I’ve tried differing tools but can’t find a good solution, please help.

Got an example spreadsheet? Struggling to follow your explanation

:confused: Lost me… :shrug:

Ended up using a search type function I found, works well and co’s it’s a function I can re-use it.

Ta anyways