Need help with formula

CCopete

New Member
Joined
Mar 2, 2019
Messages
1
I have a spreadsheet with products and prices. I need in my sales spreadsheet that if the product name is B the price is C, if the product name is D the price is E etc. I have around 80 products. I have tried all the way possible with the IF function but cannot make it work. Thanks
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

silentwolf

Well-known Member
Joined
May 14, 2008
Messages
1,123
Office Version
  1. 2016
HI,
you need a vLookUp formula for this kind of situation.
There are many examples on the net to get you started.

HTH
 

Watch MrExcel Video

Forum statistics

Threads
1,108,492
Messages
5,523,260
Members
409,506
Latest member
reneekeane

This Week's Hot Topics

Top