IF Function-IF criteria is met i need a lookup and calculation

Hi

below is a basic spreadsheet for what i require. 

Prolem

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.

By: Ayes

Leave a Reply

Your email address will not be published. Required fields are marked *