Here is my latest...
I have a sheet (sheet1) with 3 columns - Item, Quantity, Cost
I have a second sheet (sheet2) with 3 columns - Item, Description, Cost
I'd like sheet1's cost column to match an item within a row to the same item on sheet2, find the sheet2 cost, and multiply it by the sheet1 quantity.
ex...
sheet1
----
a, b, c
computer, 2, ??
phone, 1, ??
sheet2
-----
a, b, c
computer, P4 Dell, 100
phone, polycom 2000, 50
sheet1 would then match 'computer' and 'phone' within sheet2 and perform the calculation
----
a, b, c
computer, 2, 200
phone, 1, 50
I have yet to be dissapointed with the Excel wizards here. Thanks guys!
I have a sheet (sheet1) with 3 columns - Item, Quantity, Cost
I have a second sheet (sheet2) with 3 columns - Item, Description, Cost
I'd like sheet1's cost column to match an item within a row to the same item on sheet2, find the sheet2 cost, and multiply it by the sheet1 quantity.
ex...
sheet1
----
a, b, c
computer, 2, ??
phone, 1, ??
sheet2
-----
a, b, c
computer, P4 Dell, 100
phone, polycom 2000, 50
sheet1 would then match 'computer' and 'phone' within sheet2 and perform the calculation
----
a, b, c
computer, 2, 200
phone, 1, 50
I have yet to be dissapointed with the Excel wizards here. Thanks guys!