Selecting a client to show specific price list

Having trouble attaching an example, but I would approach this by creating a table of prices vs client (including a general case) and then use a combination of the INDEX and MATCH functions to return the specific price list you need. I will upload an example when able.

EDIT:

OK, example now attached.

If you in put client A, B or C in cell B1, the appropriate prices will be returned to cells E1:E3. If the client is not found, it will return the general price.

Have a play with it, and post your issues, if you have any!

Originally Posted by josephteh

Alternative formula for cells E1 to E3: = OFFSET($H$9,IFERROR(MATCH($B$1,$H$9:$H$13,0),2)-1,MATCH($D1,$H$9:$K$9,0)-1)

This will work just fine too, but be aware that OFFSET is not robust to the addition or removal of columns / rows, and is a volatile function, so will be resource heavy.