Xlookup with Nested IF - Advice

Our take

Navigating Excel can be challenging, especially when dealing with varying supplier rates in a purchase order. If you’re using XLOOKUP effectively for most of your sheet but need assistance integrating a nested IF function, you're not alone. In your case, you want to pull the correct price based on both the product and the selected supplier from your Price Book tab to your Purchase Order tab. This approach will streamline your order process, ensuring accurate pricing while maintaining clarity in your spreadsheet.

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…

submitted by /u/Sweaty_Sprinkles_539
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#financial modeling with spreadsheets#generative AI for data analysis#natural language processing for spreadsheets#Excel compatibility#Excel alternatives#rows.com#big data management in spreadsheets#conversational data analysis#cloud-based spreadsheet applications#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#Xlookup#Nested IF#Excel