Vlookup on multiple table array

W

Winson

there is a summary source, i have 6 different sources. i want to lookup from
the summary source whether the 6 different sources exist in the summary? may
i know how to lookup multiple table arrays? thx.
 
D

Dave Peterson

I'd just use 6 different cells and use a formula that points at the 6 different
sources.

There is no =vlookup() trick to look through multiple lookup tables.
 
Top