R
Rich
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
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