Double Vlookup

[Johnny Thunder]

I just need help format my formula

here is the first one, =VLOOKUP($A:$A,'LMSi User Accounts'!$A:$F,6,0)

here is the second part of the formula, =VLOOKUP(A:A,Definitions!A:B,2,0)

I am trying to combine both to say if you run the first one and return a error then look too the second lookup to find your answer.


Any help will be appreciated! thanks!!

Excel 2007

 

[VoG]

Try

=IFERROR(VLOOKUP($A:$A,'LMSi User Accounts'!$A:$F,6,0),VLOOKUP(A:A,Definitions!A:B,2,0))