Forum Discussion
Simple Nested if to bring price of the product
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 ...
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)