Hello All,
I have attached my problem workbook in explanation, I need help of pulling values from particular data by referencing selection in drop down list via some formula. I thought about using the SUMPRODUCT and VLOOKUP but couldnt reference the values in drop down list.
Hope my example helps the full explanation.
Thanks in advance for your help and support.
NK
Last edited by NKRA; 11-12-2008 at 01:54 PM.
Your posted workbook doesn't seem to define Types 1,2, or 3.
Absent that information...try this
Copy that formula down and across through X5.J3: =VLOOKUP($C$12,$B$15:$Q$19,MATCH(J$2,$B$15:$Q$15,0),0)
Is that something you can work with?
Magic formula worked, but with further review and my need. I have additional step to be performed.
I have updated the excel workbook with details behind the same. I would need suggestion as well as formula for step 2.
Thanks in advance for the help
Hope this solves my problem.
NK
Here is the way I have figured out to do the step 2.
Can someone validate if this is right way to do
=(IF(($C$13="Regular"),(((SUM(J3:X3))-(J3+K3))),(IF(($C$13="Polished"),(((SUM(J3:X3))-(K3+L3))),(IF($C$13="Grained",(((SUM(J3:X3))-(J3+L3))),0))))))
Last edited by NKRA; 11-12-2008 at 01:17 PM.
Can someone please validate? If I have the right way captured of doing the Step 2?
Regards
NK
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks