I am very new to this and based on what I have read I need to create a VLOOKUP formula to accomplish a task that I THINK should be very easy, but many hours later I'm finding that it isn't easy for me! I think I'm on the right track to make this work but I'm open to any and all suggestions on how to make this work better
My scenario:
I have a worksheet that has cells with a drop down box - listed on sheet 2 of my book. When someone selects an item from the drop down box I need a % that is in the cell next to that list to populate in the cell to the right of the drop down box. I then need that % to be applied to a total volume number.
Example
worksheet 1
Columns
G H I
Drop Down Box % Total of I x B5
worksheet 2
Columns
A B
Choice ABC 1.5%
Thanks for any help out there!
My scenario:
I have a worksheet that has cells with a drop down box - listed on sheet 2 of my book. When someone selects an item from the drop down box I need a % that is in the cell next to that list to populate in the cell to the right of the drop down box. I then need that % to be applied to a total volume number.
Example
worksheet 1
Columns
G H I
Drop Down Box % Total of I x B5
worksheet 2
Columns
A B
Choice ABC 1.5%
Thanks for any help out there!