Iglookup Alternatively

Iglookup Alternatively. The vlookup and hlookup functions, together with index and match,  are some of the most useful functions in. For alternative to vlookup, we need to remember the column number in case of many columns, but in these formulas,.

On august 28, 2019, microsoft announced the release of the xlookup function. By combining the index and match functions, we have a comparable replacement for vlookup.