Vlookup + match formulas (probably)

[vettel75]

Hi,
couldn't quite find a similar problem throughout the forum, so maybe someone will be able to help me out.

What i have is a simple list of same item people bought all over US and i will bringing those items to Chicago. What i have is different groups of clients who have different pricing for transportation from same places.
How can i make a vlookup to deliver prices for VIP clients, not the general ones? Also, if i have lots of different clients how do i make them all fall under general pricing?

I'm enclosing the example sheet.
I marked red what i'm talking about and comments on the right of it.

Hope i made the problem understandable

[Fluff13]

Hi & welcome to the board
How about
=INDEX($O$17:$R$21,MATCH(B5,$N$17:$N$21,0),IFERROR(MATCH(INDEX($O$5:$O$10,MATCH(D5,$N$5:$N$10,0)),$O$16:$R$16,0),1))

[vettel75]

wow, that's great. Will take a couple of days probably to understand the code but yeah, that's what i needed.

Thanks!

[Fluff13]

You're welcome & thanks for the feedback.

If you select the cell with the formula, then on the Formulas tab click "Evaluate formula" you can step through the calculation process. Which may help you to understand what is happening.