Combining lookups

[madmat33]

Hello

Is it please possible to combine lookups (or some other function) like this:

I have list of customers with different standard values (lets say quantities). Each standard quantity has its own price for each customer. Now I need to find that price, but quantity is not the same as standard, so I need it to find closest one. Please see attached sample file.

Thank you for help

[WideBoyDixon]

Try this in H3:

Please Login or Register  to view this content.

WBD

[madmat33]

Exatly what I needed. Thanks a lot.