Vlookup simple Help

[igorski88]

I am using the following formula to find the data im searching for but not all the sheets have the data its looking for if not I want it to keep adding the rest of the sheets without an error code.

=(VLOOKUP(A5,sheet1!A3:E14,5,FALSE))+(VLOOKUP(A4,sheet2!A3:E14,5,FALSE)+(VLOOKUP(A4,sheet2!A3:E14,5,FALSE))

 

[igorski88]

Perfect. Thanks for all your help!!!!

 

[T. Valko]

Perfect. Thanks for all your help!!!!

You're welcome. Thanks for the feedback!

 

[igorski88]

I just wanted it to look pretty!!