Xlookup with Nested IF - Advice

Hi Guys,

I'm working on an Excel sheet, and I'm stuck with something that I shouldn't be stuck with!!

Basically, I'm creating a Purchase order that I will print/Email to suppliers, I use various suppliers with all slightly different rates for the same product... I've used Xlookup for most of the sheet being the elegant to solve the various requests, but I'm assuming I need an Xlookup with a Nested IF to settle this issue...

2 Tabs are being used:

• 1^st Tab (Price Book)This is used to store product descriptions(horizontally) and there costs from Different suppliers (vertically).
• 2^nd Tab (Purchase Order)This Tab is a print ready form that is simple, However the bit I’m struggling with is the price part.

I select the product from a Data Validation List (Price book) which then populates most of the Purchase Order. I then want the price to be pulled through based on the supplier I have selected for that Purchase Order....

Hope this makes sense…