Sheet 1
A B C AA
1 JR Jan german
2 JJ Jan american
Sheet 2
A B C AA
1 Jan Feb Mar
2
3
100 JJ
***What i need the formula in cell b1 to do is: if b1 sheet2 is equal to cell b1 in sheet1, then look for "JJ" sheet2 in the range of column A of sheet1. If the record is found then give me the value of column AA that corresponds to JJ in sheet1.
Please help, I have been trying to get this since tuesday. Thank you very much.
- Moved by Lanlan HuangMicrosoft contingent staff Friday, July 10, 2015 3:02 AM