Which Formula ?

[Tofik]

Hi guys which simple formula I can use to fill empathy cells (Problem is Welder 1 and Welder 2 can be duplicated in different rows)
I found a website with a different variety of fformulars.

500 Excel Formulas

Over 500 working Excel formulas with detailed explanations, videos, and related links. Includes key functions like VLOOKUP, XLOOKUP, INDEX & MATCH, FILTER, RANK, ROUND, AVERAGE, COUNTIFS, SUMIFS, UNIQUE, SORT, TEXTSPLIT, and more.

exceljet.net

Welder 1	Welder 2	RT Report			Welder	RT report
PW-035	N/A	SRT-MQS-0005
PW-013	N/A	SRT-MQS-0006
PW-030	N/A	SRT-MQS-0003
PW-007	N/A	SRT-MQS-0004
PW-031	N/A	SRT-MQS-0008
PW-001	N/A	SRT-MQS-0021
PW-034	N/A	SRT-MQS-0007
PW-035	N/A	SRT-MQS-0001
PW-005	N/A	SRT-MQS-0002
PW-007	N/A	SRT-MQS-0009
PW-036	N/A	SRT-MQS-0010
PW-030	N/A	SRT-MQS-0012
PW-001	N/A	SRT-MQS-0011
PW-049	N/A	SRT-MQS-0018
PW-001	N/A	SRT-MQS-0013
PW-001	N/A	SRT-MQS-0014
PW-007	N/A	SRT-MQS-0016
PW-005	N/A	SRT-MQS-0015
PW-013	N/A	SRT-MQS-0017
PW-050	N/A	SRT-MQS-0040
PW-042	N/A	SRT-MQS-0022
PW-049	N/A	SRT-MQS-0050/0042
PW-048	N/A	SRT-MQS-0023
PW-050	PW-044	SRT-MQS-0019
PW-040	N/A	SRT-MQS-0038
PW-040	N/A	SRT-MQS-0039
PW-045	N/A	SRT-MQS-0041
PW-049	PW-048	SRT-MQS-0020
PW-044	PW-050	SRT-MQS-0028
PW-067	N/A	SRT-MQS-0030
PW-048	PW-049	SRT-MQS-0027
PW-005	N/A	SRT-MQS-0051/0029
PW-043	N/A	SRT-MQS-0024
PW-013	N/A	SRT-MQS-0032
PW-007	N/A	SRT-MQS-0034
PW-003	PW-026	SRT-MQS-0044
PW-037	N/A	SRT-MQS-0033

 

[Tofik]

Why it is not working ? ((((

 

[Tofik]

 

[Tofik]

May be I have the problem because of = , or it cannot affect on the your formula ??? I collect only RT information from my main log.

 

[Tofik]

up

 

[Tofik]