Forum Discussion

RepublicsFury's avatar
RepublicsFury
Copper Contributor
Aug 23, 2020
Solved

Create a formula to fill in data based on cell

I would like to create a formula that fills in Cell (column) BX based upon the input in cell AX.   A1: Cow A2: Chicken A3: Pig   B1: $400.00 B2: $5.00 B3: $50.00   So my thoughts are someth...
excel
Formulas and Functions
Macros and VBA
  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Aug 23, 2020

    RepublicsFury 

     

    The formula should be like this...

     

    =IF(A1="Cow",400,IF(A1="Chicken",5,IF(A1="Pig",50,"")))

     

    But I would suggest that instead of hard coding the item and it's price in the above formula, you should create a price list somewhere in the file and then you can use VLookup formula to get the priced of the item you input in column B.

     

    The attached has two sheets which show both the methods.

     

Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Aug 23, 2020

RepublicsFury 

You're welcome! Did that resolve your issue? If yes, please take a minute to accept the post with the proposed solution as a Best Response in order to mark your question as Solved.

RepublicsFury's avatar
RepublicsFury
Copper Contributor
Aug 23, 2020

Subodh_Tiwari_sktneer 

 

New at the posting and accepting... .thanks for the help.

 

I think I did it right and accepted that as the right response. It did solve the issue. I'll create the Price List on a Worksheet and then use that as the reference for the formula on each other Worksheet inside the Workbook.

 

Thanks again!

 

- RF

  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Silver Contributor
    Aug 23, 2020

    RepublicsFury 

    Thanks! You correctly marked the proposed solution as a Best Response.

     

    Stay safe and healthy

    Have a nice weekend!

Resources