Hi! Need your expert help folks. Seen screenshots attached. I need a formula to find the data in the array of column 'C' on worksheet 'TRADE TEMPLATE' (screenshot #1), that matches the data in the array of column 'B' on worksheet 'Act Cur to Base Cur' (screenshot #2), and then return the value in the cell that is in the adjacent cell that is in column 'C' to the matching data on 'Act Cur etc.' (screenshot #2).
Thanks
Screenshot#1
1.jpg
Screenshot#2
2.jpg
Bookmarks