Quote:
Originally Posted by M3 Number 86
Index match is always superior. Or lookup with match for column header at least.
Indirect is the best.
|
Yes.... INDIRECT has much more flexibility. Still use VLOOKUP if I know it's a finite 1:1 and need a quick and dirty pull-in.
Inb4. No innuendo intended....