Dear all,
I am looking for a formula, the condition is if the either column B1 or C1 in sheet1 can be found in sheet2 A:A, bring B1 or C1 which matchs sheet2 A:A to column E1, and if there is no matches, put USD in E1. I have attached the template, please help to advise, thanks!
Bookmarks