formula to find a cell value based on 2 criteria

[cjcass]

Hi,
Am looking for a formula that will look at cell A1 (which contains a wksht name eg. 'Data') and cell A2 (which contains a header value in Row 3 of that wksht eg. 'Apples') which returns the value of the cell that is in Row 4 below the header.
So, in this example the formula goes to wksht 'Data', finds the header 'Apples' in Row 3 and then returns the value one cell below the header in Row 4.
Hope you may be able to help.
Many thanks.

 

[wideboydixon]

=iferror(offset(indirect($a$1&"!a3"),1,match($a$2,indirect($a$1&"!3:3"),0)-1),"")

wbd

 

[cjcass]

Many thanks WBD - works great