Thanks for the help in advance!
I have a table full of campaign data. I need to write a function to see a column "IO Number" on Sheet 2, Column A, in this example "AM262" and then see on Sheet 1, Column C if that name appears. In this example it does, but it looks like this "IO-AM262". If so, go to Sheet 2, find the corresponding exchange rate in C2 and return it.
SO, look at S2, CA and find it at S1, CC and return S2, C1.
More complicated example: find KP1002 in S2, A40 in S1, C24 (text: 2020 | Q2 | Sage | MEA | ZA | Small | Social_SMBS_KP1002) and return R14.95 in S2, C40)