I need a formula that would choose one array to index if it matched one cell or choose another array to index if it matched another cell. Basically I am trying to get pricing out of an array for regular customers and preferred customers. The formula I would use if I was only choosing from one array would be =index(shipping, $P3,$N3) I want to reference the cells in column Q in order to then reference the correct shipping price array.
Solved by O. C. in 20 mins