ozbeachbum
Board Regular
- Joined
- Jun 3, 2015
- Messages
- 197
- Office Version
- 2021
- Platform
- Windows
I am looking for a formula for the following.
I have a sheet named Debit Est and another sheet named Data.
Destination range is Debit Est J70:J210
Target Ranges are Debit Est H70:H210 Data FP70:FP210 & FT70:FT210
EG:
Debit Est H70:H210 Data FP70:FP210 Data FT70:FT210 Debit Est J70:J210
TEST 1 TEST 1 John John
RUN 1 RUN 1 David David
RUN2 MARK 0 Wilson IGNORES ENTRY
TEST 2 TEST 2 Tim Tim
MARK1 MARK 1 Karen Karen
Entries in Debit Est H70:H210 may not be in the same order as the Entries in Data FP70:FP210
I have a sheet named Debit Est and another sheet named Data.
Destination range is Debit Est J70:J210
Target Ranges are Debit Est H70:H210 Data FP70:FP210 & FT70:FT210
EG:
Debit Est H70:H210 Data FP70:FP210 Data FT70:FT210 Debit Est J70:J210
TEST 1 TEST 1 John John
RUN 1 RUN 1 David David
RUN2 MARK 0 Wilson IGNORES ENTRY
TEST 2 TEST 2 Tim Tim
MARK1 MARK 1 Karen Karen
Entries in Debit Est H70:H210 may not be in the same order as the Entries in Data FP70:FP210