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

 

[Alex Blakenburg]

You're welcome. Glad I could help.

 

[Peter_SSs]

Sorry, I just feel like I'm missing a critical piece here.

That may be so, but you are also missing the correct syntax for XLOOKUP which is

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

Your formula in column O will look something like this:

=XLOOKUP(F2,MasterList!$A$2:$B$14,2,FALSE, delivery_date)

Your formula appears to be a mixture of XLOOKUP and VLOOKUP syntax.