Condense multiple Formula's into 1

[mecheet]

I have 4 formulas that are being used to get me a value that i require.

They sit in 4 columns side by side, is it possible to have these reduced into a more manageable formula?

AD5
=VLOOKUP(F5,notes!A8:B43,2,FALSE)+7

AE5
=VLOOKUP(AD5,notes!B8:C43,2,FALSE)

AF5
=ISERROR(AE5)

AG5
=IF(AF5=FALSE,AE5,"")

Thanks

 

[Scrappy666]

Hi,

Try -

=IF(ISERROR(VLOOKUP(VLOOKUP(F5,notes!A8:B43,2,FALSE)+7,notes!B8:C43,2,FALSE))=FALSE,VLOOKUP(VLOOKUP(F5,notes!A8:B43,2,FALSE)+7,notes!B8:C43,2,FALSE),"")

All i've done there is simply put each formula into the one below to make it all fit in one cell.

 

[mecheet]

Thanks for that, i wasnt aware that placing an = mid formula would allow a totally seperate forumla to be run based on the previous output.