Help with a formula IF THEN with VLOOKUP

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. 

July 9th, 2015 2:56pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics