You have the right idea. You just need to finish it:

=IF(VLOOKUP(B1,Matrix,2,0)="Unknown",VLOOKUP(C1,Ma trix,2,0),VLOOKUP(B1,Matrix,2,0))--BiffMicrosoft Excel MVP"John Moore" wrote in ... Hi guys, I am trying to use an IF statement with a VLOOKUP function toreturn data based on one of two criteris ,, e.g. column A is where I want toplace the formula, column B is the first criteria, column C is the 2nd criteria ,,,, what I want to see in column A is the result from doing a VLOOKUP on column B ( using a matrix ) and if the return data is "Unknown" thenVLOOKUP column C and return the result form the same matrix ,,,, i.e. If(VLOOKUP(B1,Matrix,2,0)="Unknown",Vlookup(C1,mat rix,2,0) ...... anyoneknow of an easy solution? A B C nuts Bolts