Microsoft Office Forums - View Single Post - Calculate formula base of list menu

Thread: Calculate formula base of list menu

View Single Post

Old

09-20-2010, 10:07 AM

Kimberly

Kimberly is offline

Kimberly uses Windows 7

Windows 7

Kimberly uses Office 2010 (Version 14.0)

Office 2010 (Version 14.0)

Expert

Join Date: May 2010

Posts: 517

Kimberly is on a distinguished road

Default

=HLOOKUP(E6,$A$2:$C$3,2,0)*D6
in cell G6 and copy down

By the way, you are multiplying in column G, but doesn't the label in cell G5 imply division?

Reply With Quote