I have data in about 8 different sheets. I am creating a master sheet that
consolidates some of the data from the 8 sheets (while keeping active
links/vlookups to the data). I would like to change my vlookup array based
on the "ID number". For example, if id number="abc", then vlookup(a1,
sheet1!A:C, 2, false), if id number =xzy, then vlookup(a1, sheet2A:C, 3,
false). The problem is that I have 24 different ID's (hence arrays) to lto
work with. I tossed around the idea of creating a reference table for the
IDs/Arrays, and doing a lookup to find the array within the lookup to grab
the data, but it dosen't seem to work. Anyone know of a good way to do this?