Aug 31 2022 01:32 PM - edited Aug 31 2022 01:33 PM
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'$F$2:$G$22;2;FALSE);"NO DATA")
(in NL) =ALS.FOUT(VERT.ZOEKEN(I2;TabbladB'$F$2:$G$22;2;ONWAAR);"NO DATA")
Does exist another formula to search this?
Tabblad A
tabblad B (transport company where is the correct KG)
Aug 31 2022 01:41 PM
SolutionThe attached version demonstrates three different formulas. "Formula 2" will only work in Excel in Microsoft 365 and Excel 2021.
Sep 04 2022 12:58 AM
Aug 31 2022 01:41 PM
SolutionThe attached version demonstrates three different formulas. "Formula 2" will only work in Excel in Microsoft 365 and Excel 2021.