Soldato
- Joined
- 13 Jan 2004
- Posts
- 12,773
- Location
- Leicestershire
hey, i need help on an excel formula for work. i've kinda done in a workaround bit but i know theres a way of doing this but i cant think of it for the life of me.
im guessing ill need VLOOKUP or IF ranges.
basically i have a range of number in e.g. column A on sheet 1, and similar values in column A on sheet 2. i want to link sheet 2 to the range on sheet 1 and get it to search or 'lookup' the cell value and if it finds it to change colour to green ala conditional formatting.
how would i go about it?
i've already done the work, but for my mind i'd like to know and learn a bit more about excel.
im guessing ill need VLOOKUP or IF ranges.
basically i have a range of number in e.g. column A on sheet 1, and similar values in column A on sheet 2. i want to link sheet 2 to the range on sheet 1 and get it to search or 'lookup' the cell value and if it finds it to change colour to green ala conditional formatting.
how would i go about it?
i've already done the work, but for my mind i'd like to know and learn a bit more about excel.
