Match data in one sheet with data in another sheet

[ozbeachbum]

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

 

[myall_blues]

Is this how you mean?

Put this formula in 'Debit Est'!J70 and copy down.

=FILTER(Data!$FT$70:$FT$210,$H$70:$H$210=Data!$FP70,"")

 

[ozbeachbum]

Great, works perfectly.
Thanks.