Reply to thread

Message: [QUOTE="Duke Carey, post: 3857822"] Assuming your 10 price lists do not run to more than 6,500 rows each, you can do this in a straightforward way with a single lookup range. Stack each of your price lists one on top of the other, in columns C:E In column B r each list have the number corresponding to your which_price variable. In column A simply concatenate columns A & B, perhaps with a separator like so: =A1&" - "&B1 Name the whole range, columns A:E, PriceList. Now your ENTIRE lookup formula would be =vlookup(which_price&" - "&B26,PriceList,5,0) [/QUOTE]