C3 in Sheet 2 needs to contain the value of G3 in Sheet 1 IF B3 in sheet 1 contains a specific text and C3 in Sheet 1 contains a specific text -
So for example, If a driver whose name gets entered via drop down in Sheet 1, B3, has an incident, the title of which is entered by drop down in Sheet 1, C3, then the cost of that incident is entered into Sheet 1, G3. The value in Sheet 1 G3, then needs to be entered into Sheet 2, C3.
Help!
Bookmarks