Can someone clue me in on the best way to get a VLOOKUP formula to work with a 3-D range, short of replicating the ranges in a single sheet?

Thanks

Steve