Automatic updation of data based on the entry

[depks]

Good day..
I have the following data.
1 2 3 4 5
Tank1
Tank2
Tank3
Tank4
Consider this data
Date Tank No. Description
2 Tank2 Received

Corresponding intersecting cell if Date 2 and Tank No to be filled
With the Description typed automatically.

 

[fairwinds]

Hi,

Try:

=IF(ISNUMBER(MATCH(B$1&"@"&$A2,$A$8:$A$20&"@"&$B$8:$B$20,0)),INDEX($C$8:$C$20,MATCH(B$1&"@"&$A2,$A$8:$A$20&"@"&$B$8:$B$20,0)),"")

in B2, confirmed with Ctrl + shift + enter and then dragged right / down

Book1
	A	B	C	D	E	F
1		1	2	3	4	5
2	Tank1				xxxx
3	Tank2		Received
4	Tank3
5	Tank4
6
7	Date	Tank No.	Description
8	2	Tank2	Received
9	4	Tank1	xxxx
10
Sheet5