Hi,
I want to search through two rangea and match two criteria, then display text from an adjacent cell from the first time that match it successful.
Have attached an example of the spreadsheet.
Looking to match a value in range B2:B23 to a value in D2:D23 and when there is a match (there may be multiple matches) display the text in an adjacent cell (range f2:f23) from the first time that match it successful.
Have given an example of the values I am looking for located in L7, L8 & L9
Thanks
Bookmarks