Hi all,
Long time lurker. This is probably a relatively easy fix, but I'm trying to create a breakdown of materials/quantity based on two variables from the "Materials" sheet.
A2 is a dropdown list of Items and Columns C-D would display the Material and Quantity needed for that specific item. I tried doing a VLOOKUP, but that seems to be the wrong function for something like this? If someone could point me in the right direction, it would be much appreciated. Thank you
try D2: =INDEX(Materials!$B$2:$K$5,MATCH($A$2,Materials!$A$2:$A$5,0),MATCH($C2,Materials!$B$1:$K$1,0)) and drag down to the end of data
for 2nd example formula is similar
I notice you said Vlookup....
here is: =VLOOKUP($A$2,Materials!$A$2:$K$5,MATCH($C2,Materials!$A$1:$K$1,0),0)
as above for 2nd example formula is similar
Last edited by sandy666; 06-16-2017 at 09:48 PM.
That formula worked, but C2 should be blank until A2 is selected. So columns C and D will list only the materials/quantity relevant to that item, does that make sense?
Item 1 might only have 3 materials, so it will only list those three materials instead of having a master list of materials in the C column.
Oh, ok. I'll look at this later
Last edited by sandy666; 06-17-2017 at 01:56 AM.
Hi again
I think with PT will be much easier and faster
see attachment:
Last edited by sandy666; 06-17-2017 at 01:56 AM.
This is perfect, thank you!
You are welcome
here is simpler version with the button for refresh and sort PT but file should stay with xlsm extension because of a little vba inside.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks