Forum Discussion
Solved
Xlookup not returning value for all cells that match criteria
I am handling data on a month to month basis of around 800-1300 tickets so I needed an easy way to edit prices that change on a month to month basis for both a Sale and Purchase side of transactions....
It sounds like there's a calculation crunch in your workbook.
I'd start with using specific references in your XLOOKUP:The bolded parts need to be updated. Even if you point them at 10,000 rows, it's going be faster than having Excel check the entire column.
=XLOOKUP(G434,Pricing!E:E,Pricing!G:G,XLOOKUP('Full Ticket Listing'!E434&'Full Ticket Listing'!F434,Pricing!T:T,Pricing!W:W))
You need to specify more details about this issue, I suggest you have some files or screenshots attached. Seems more like there is some mistyping error in XLOOKUP function.