Urgent help require to fill blank cell.

[alt_tush]

Hi All,

I have below data (Table1). I want to update only blank cell in Filed3 wherever Field1=Field2

For example for first case where 100=100 their field3 value in blank cell should be ABC100 and same for others.

Table1

Field1	Field2	Field3
100	100
100	100
100	100	ABC100
200	200
200	200	XYZ200
300	300
300	300	PQR300
300	300
300	300
400	400
500	500	STU500

Expected output should be 

Field1	Field2	Field3
100	100	ACB100
100	100	ACB100
100	100	ACB100
200	200	XYZ200
200	200	XYZ200
300	300	PQR300
300	300	PQR300
300	300	PQR300
300	300	PQR300
400	400	PQR300
500	500	STU500

Thank you in advance.

[FFFool · Accepted solution]

Edited to attach an example - I also read the word "field" so many times I was sure it was spelled wrong. 

First, sort your data, so it looks like this - So the cells in Field 3 that are populated are at the top of the groups of Field1 & Field2 

Field1	Field2	Field3
100	100	ABC100
100	100
100	100
200	200	XYZ200
200	200
300	300	PQR300
300	300
300	300
300	300
400	400
500	500	STU500

Then use the Multi-Row Formula tool and in the expression section put:

IF ISEMPTY([Field3]) and [Field1]=[Field2]
THEN [Row-1:Field3]
ELSE [Field3]
ENDIF

Hope that helps!

[alt_tush]

Hey Friend,

Thank a lot. It really resolved my Problem.

Have a nice day 🙂