So I am attempting to make a pricing cheat sheet for my work. I have been fine with excel up until my new ambitions and I am not quite sure how it may be possible. Essentially I have an excel doc that is generated by my employer but it is long and cannot be easily printed for customer facing use. It would end up being a big packet. Anyway I have shortened it to a one pager. It looks great and I have been maintaining it for over two years. The only thing I've always hated about it is I have to manually enter values when it updates. All of the hard parts are completed with formulas but it still takes 20 minutes or so to complete. I want to be able to copy and paste the provided files and have VLOOKUP finish the rest for me. When sitting down to figure this out, I ran into another issue; this is what brought me here. This is what my setup looks like now.
<tbody>
</tbody>
I want to be able to type in the device name in column A and have the cost values populate from another tab in the workbook based on the "device name". The problem is if I type in a new device name in A2, i.e. "Better", I want cell B2 to change as well to reference the proper cost cell for "Better". So ultimately, I can just type in the names of the devices in column A and the formulas will look up the values from another tab and insert them in all the rest of the cells in that row that corresponds to the device name.
I hope this is enough explanation. I feel like this is something simple but I just cant grasp what i need to do.
Thanks!!
Device Name | cost 1 | cost 2 | cost 3 | cost 4 |
Good | $10 | $5 | $15 | $23 |
Better | $13 | $7 | $22 | $35 |
Best | $15 | $10 | $25 | $40 |
Amaze-Balls | $20 | $12 | $30 | $45 |
<tbody>
</tbody>
I want to be able to type in the device name in column A and have the cost values populate from another tab in the workbook based on the "device name". The problem is if I type in a new device name in A2, i.e. "Better", I want cell B2 to change as well to reference the proper cost cell for "Better". So ultimately, I can just type in the names of the devices in column A and the formulas will look up the values from another tab and insert them in all the rest of the cells in that row that corresponds to the device name.
I hope this is enough explanation. I feel like this is something simple but I just cant grasp what i need to do.
Thanks!!