Forum

Lookup with multi c...
 
Notifications
Clear all

Lookup with multi criteria

2 Posts
2 Users
0 Reactions
103 Views
(@bobkap)
Posts: 17
Eminent Member
Topic starter
 

Please see attached file. I need to determine the pricing based on the company, number of colors and quantity.

I thought I knew how to figure this out with a vlookup formula but I just seemed to have forgotten.

If possible, can someone please help me determine that formula to determine the price based on the 3 criteria?

Also, getting the version to use in VBA would be even better.

THANKS!

 
Posted : 25/09/2022 10:46 pm
Riny van Eekelen
(@riny)
Posts: 1193
Member Moderator
 

Hi Bob,

The file didn't come through. Please ty again and don't forget to press "Start upload" before submitting your reply.

Riny

 
Posted : 26/09/2022 8:41 am
Share: