vlookup

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
 
B

bpeltzer

=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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top