Forum Discussion
Solved
Vlookup, or alternative
Hi, I am looking to create a lookup function for a large datasheet probably 120k rows and 10 columns (roughly). I am looking to lookup using an order number or a drawing number. Sometimes we...
cleach86 Perhaps like in the attached file. The formula used is:
=XLOOKUP(D2,VALUE(LEFT(SUBSTITUTE(DrawingNrs," ",""),8)),OrderNrs,"Not found")where DrawingNrs and OrderNrs are named ranges.
Cannot predict, though, how this will perform on 120K rows,
cleach86 Perhaps like in the attached file. The formula used is:
=XLOOKUP(D2,VALUE(LEFT(SUBSTITUTE(DrawingNrs," ",""),8)),OrderNrs,"Not found")
where DrawingNrs and OrderNrs are named ranges.
Cannot predict, though, how this will perform on 120K rows,
Hi Riny,
Thank you very much for your suggestion!
I will give this a go and let you know how I get on 🙂
Appreciate your input!
Thank you very much for your suggestion!
I will give this a go and let you know how I get on 🙂
Appreciate your input!