Forum Discussion
JGA74
Aug 31, 2022Copper Contributor
Searching de KG based on the match of the order reference in two different tabel
Hi all, I need your help with a formula in excel. I'm using the formula to find the correct KG base by the order reference number on the tabblad B. (in English) =IF.ERROR(V.LOOKUP(I2;'TabbladB'...
- Aug 31, 2022
The attached version demonstrates three different formulas. "Formula 2" will only work in Excel in Microsoft 365 and Excel 2021.
HansVogelaar
Aug 31, 2022MVP
The attached version demonstrates three different formulas. "Formula 2" will only work in Excel in Microsoft 365 and Excel 2021.
JGA74
Sep 04, 2022Copper Contributor