FrigidDigit
Board Regular
- Joined
- May 10, 2005
- Messages
- 203
Hi all!
I have a summary sheet (1) with the following layout:
Mod01 Mod02 Modnn
Contractor 1 Date01 Date02 Datenn
Contractor 2 Date01 Date02 Datenn
Contractor n Date01 Date02 Datenn
On sheet 2 I have list of data
Sub Name File Name Mod # Mod Status Date
I need a lookup formula for sheet one that will lookup the date based on the contractor name and mod # on sheet 1, however if the status on sheet 2 is "Not submitted", I want to display "Pending" in the relevant cell on sheet 1.
I hope I have explained this clearly enough?
Any help would be much appreciated.
Thanks FD
I have a summary sheet (1) with the following layout:
Mod01 Mod02 Modnn
Contractor 1 Date01 Date02 Datenn
Contractor 2 Date01 Date02 Datenn
Contractor n Date01 Date02 Datenn
On sheet 2 I have list of data
Sub Name File Name Mod # Mod Status Date
I need a lookup formula for sheet one that will lookup the date based on the contractor name and mod # on sheet 1, however if the status on sheet 2 is "Not submitted", I want to display "Pending" in the relevant cell on sheet 1.
I hope I have explained this clearly enough?
Any help would be much appreciated.
Thanks FD