Quote Originally Posted by :) Sixthsense :) View Post
May be this…

In B2 Cell of Sheet1 - Array Formula - Requires CTRL+SHIFT+ENTER

=IF(MAX(IF(ISNUMBER(SEARCH($A2,Sheet2!$A$2:$B$10)),ROW(Sheet2!$A$2:$B$10))),INDEX(Sheet2!C:C,MAX(IF(ISNUMBER(SEARCH($A2,Sheet2!$A$2:$B$10)),ROW(Sheet2!$A$2:$B$10)))),"")

Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.

Drag it down…

Extend the range Sheet2!$A$2:$B$10 to your desired range…
Thank You that worked.