is =xlookup the formula I need?

[Mel Smith]

I run a weekly report that consists of a variable number of lines (500 - 1000+ lines). I have a master list of suppliers and their payment terms and I would like to automate against each line when it will fall due for payment, based on the delivery date and payment terms in my master list. Is using =xlookup the way i should go?

On my report sheet column the delivery date is in column C and supplier name in column F. I would put my formula in to column O.

Many thanks.

Mel

 

[Mel Smith]

Hello Alex,

That is awesome, thank you!

Mel

 

[Alex Blakenburg]

You're welcome. Glad I could help.