=IF(ISERROR(VLOOKUP(A13,'Q1 BS'!E:F,2,FALSE)),IF(ISERROR(VLOOKUP(A13,'Q1
BS'!D:F,3,FALSE)),VLOOKUP(A13,'Q1 BS'!C:F,4,FALSE),VLOOKUP(A13,'Q1
BS'!D:F,3,FALSE)),VLOOKUP(A13,'Q1 BS'!E:F,2,FALSE))


"Rich" wrote:

hiya

have a worksheet containing data which reads from a 2nd worksheet using the
error and vlookup function

=IF(ISERROR(VLOOKUP(A13,'Q1 BS'!E:F,2,FALSE)),VLOOKUP(A13,'Q1
BS'!D:F,3,FALSE),VLOOKUP(A13,'Q1 BS'!E:F,2,FALSE))

this formul looks for a vlookup match in either col D or E of the target sheet

can i expand this formula to also look in c should their be no match in D or E

thanks in advance