I am trying to calculate in column K, for each corresponding line, the amount in column F times the value in column H, the row corresponding to the name in column D/G. See the attached file.
Any help will be appreciated.
I am trying to calculate in column K, for each corresponding line, the amount in column F times the value in column H, the row corresponding to the name in column D/G. See the attached file.
Any help will be appreciated.
Maybe you need to use this
=INDEX($H$8:$H$15,MATCH(D26,$G$8:$G$15,0))*F26
Or
=VLOOKUP(D26,$G$8:$H$15,2,0)*F26
Last edited by AlKey; 02-27-2014 at 01:54 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
First one works! Thanks :-)
You're welcome. Don't forget to thank those who helped by clicking on Add Reputation * and please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
Thank you for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks