hi,

Im trying to perform a vlookup across 5 sheets. I have been able to do one easy and two simultaneously using the iferror function but i keep getting errors when i try to expand to more sheets.

im sure im doing something very simple wrong

This is my simple 1 lookup and iferror look up i have used -

=VLOOKUP(A7,'Coffee Bean Shop'!A5:D30,3,FALSE)

=IFERROR(VLOOKUP(A9,'Coffee Bean Shop'!A5:D30,3,FALSE),VLOOKUP(A9,Miles!A5:D20,3,FALSE))

but i cant seem to get more than 2 in one formula to work, Basically i need all these 5 lookups in one,


=VLOOKUP(A6,'Coffee Bean Shop'!A5:D30,3,FALSE)
=VLOOKUP(A6,Redber!A5:D45,3,FALSE)
=VLOOKUP(A6,Miles!A5:D30,3,FALSE)
=VLOOKUP(A6,Rave!A5:D30,3,FALSE)
=VLOOKUP(A6,Pennine!A5:D60,3,FALSE)

Am i going about this wrong?

Any ideas please?

thankyou