Result from an adjacent cell after a worksheet search

[BrianOfNazareth]

1	123	2	456	3	789	4	963
5	852	6	741	7	147	8	258
9	369	10	987	11	654	12	321
13	123	14	741	15	789	16	741
17	852	18	987	19	159	20	987
123	?
852	?
456	?
741	?
789	?
963	?

Good evening,

I am looking for help with a search function.

I would like to search for the values in cells A7 to A12 within the range A1:H5 Then when the relevant value is found, return the value of the immediate left cell. If the value is found more than once then only return the highest 'left' number.


Thankyou in advance for any help that you can offer

[NBVC]

Try:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and not just ENTER, then copy down.