Conditional copy formula contents from one cell into another cell

[fozzie]

I am interested in automatically populating a cell based on modifying the formula used to populate another cell on the same worksheet. I have attached an example of what I am desire to do. On the Quote tab, cell B25 I have copied the data from the Price List tab, cell B2 ('Price List'!B2). Based on the formula used to populate this cell ('Price List'!B25) I want cell H25 ('Price List'!H25) to automatically populate with the data on the Price list tab C2 and cell I25 ('Price List'!I25) to automatically populate with the data on the Price list tab D2.Quote sample.xlsx

[Kevin UK]

Hi fozzie

Do you mean something like this. I have used the INDEX & MATCH but you could use VLOOKUP.

[fozzie]

Kevin,

Thanks for the formula. Works perfectly!

Fozzie

[Cutter]

@ fozzie

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[fozzie]

Cutter,

Thanks for the advice and please do mark this as solved. I did click on Kevin's star.

[Kevin UK]

Hi fozzie

Thank you for the feed back.

Kevin