Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Simple Nested if to bring price of the product

Copper Contributor

Hi,

I need a simple excel formula to price over Three hundred products. So Column 1 would be the model numbers and Column 2 would be the price of the product. 

In the third column if I enter the model number it should bring the price of the corresponding model. I tried it with the nested IF formula but it doesn't allow me to enter over 64 level. 

I can share the sample excel file if required.

Your help will be much appreciated. image_2023-10-08_220346560.png


Thanks & Regards,

Chintan

2 Replies

@chintanvisharia 

That could be

=IFERROR( INDEX(<price per piece column>, MATCH(<model>, <model No column>, 0 ), "not found" )

 

There are two scenarios:

 

1. If you have model numbers and prices in Columns A and B, you can use VLOOKUP to retrieve the price by entering a model number.

 

2. If you want prices to appear automatically in Column 4 when you enter model numbers in Column 3 (as shown in the screenshot), you can use the IF function.

 

For better understanding, please upload the sheet to Google Drive and share the link.

 

Please consider giving it a 'thumbs up' if the response was helpful for you. (external links removed by moderator)

 

@chintanvisharia