Forum Discussion

Copper Contributor

Oct 03, 2022

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....

excel

Formulas and Functions

office 365

Patrick2788
Oct 04, 2022
Peter9327
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))

mathetes

Silver Contributor

Oct 04, 2022

Peter9327

As of this writing, you've had over 50 views and no replies. Let me suggest that you help us help you by finding a way to post your file (or an accurate mockup, if the actual contains confidential data), so that we can see the actual layout of the data AND the formula itself. You refer to it as a formula that contains an XLOOKUP function nested in yet another XLOOKUP, but don't actually show the formula. That makes it hard to offer any help beyond a platitude--"hang in there."

If you are not able to post the file here, post it in OneDrive or GoogleDrive (or some comparable cloud service), and post a link here. Make sure to grant access as well so that we can open it.