Lookup data and return the value 4 rows down and 1 colom left

Hi Everyone

Hope you are all save and keeping well and busy in these crazy times.

Would you be able to please help me,
I am not an excel boffin but have a file which i need help with.

Thee files attached is the way my files are setup it is much bigger but this is just the setup so that you can see how the files look.

I have 2 files
The results file that have multiple tabs which must lookup data in the data file and bring the answer back to b4 in the results file

In the files attached I need to look up "atx" ("b2" from the results file) in the data file, if it finds Atx in row a8 to ae 8 in the data file it must return the number which is 4 rows down and 1 column to the left. (89.3) in B4 in the results file

I will use the same formula on every tab in the results file ie jkl in the file attached

you will see there are spaces between my data an also open lines will this cause issues?

B2 will always be the sheet name, is there a way that you can look up the sheet name instead of B2 bring back the result

know this may sound a bit confusing but really hope one of you clever people can help me.

Kind Regards
And thank you very much

Administrative Note:

You have been a member long enough to know that almost everyone needs help with an Excel formula ...

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

That's better - Thanks.

Are you still using Excel 2007? If not, please update your forum profile.