Trying to work on formula based on looking for month and then multiply by values in adjacent cell, currently using the following formula but it has too many arguments and cant be updated if new month is added.
tried sum product but couldn't generate a workable formula. therefore need help in nesting this formula or any other way to calculate.
=IF(B2=N$2,A2*P$2,IF(B2=N$3,A2*P$3,IF(B2=N$4,A2*P$4,IF(B2=N$5,A2*P$5,IF(B2=N$6,A2*P$6)))))
d2 = A2*VLOOKUP($B2,$N$2:$P$31,3,0) and drag down.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
try a lookup instead
=INDEX(P:P,MATCH(B2,N:N,0))*A2
and copy down
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Any alternate to Vlookup ?, actual data consist of 0.5+ million rows, wouldn't it slow down my sheet?
many thanks.....
Try it and see what happens.Originally Posted by tabkaz
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Hi Tabkaz
Try this in E2 and drag down =VLOOKUP($B2,$N$2:$P$31,3,FALSE)*$A2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks