below is a basic spreadsheet for what i require.
In the RATE cells i need the following input.
I want a search to be done in the REd category column. IF it is C3, then i want the RED deignation to be checked.
Thereafter I want the corresponding GREEN designation’s (elsewhere on spreadsheet but tyhe same as the RED one) rate to be automatically put into BLUE rate column.
Help would be appreciated.