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
Bookmarks