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
Bookmarks