Hello

I would like help with the following question

for the following table in sheet 1 A2:D5

1 2 3
a Joe Mary Adam
b Mike Erin Steve
c Ann Ken Jill

In sheet 2 Iets assume I have the following in a row

b apple cat Brown Steve


I woudl like a formula that takes "b" and "Steve" from Sheet 2 then goes to Sheet 1 and looks for the row that has "b" then looks for "Steve" in that row data then returns 3 as a result (Column Heading)

Please note on Sheet 1 I have 5000 rows of data and and Sheet 2 I have another 5000 rows and about 100 columns, so I will be copying and pasting the formula many times.

Is this possible?

Thanks for the help.