Hi All
This is my Data:
Capture.PNG
What formula would I use to get the amount of items in the Factory. Vlookup always brings up the last result, so I can not use that
Thank you for looking for me.
Hi All
This is my Data:
Capture.PNG
What formula would I use to get the amount of items in the Factory. Vlookup always brings up the last result, so I can not use that
Thank you for looking for me.
Last edited by Narghile; 09-25-2019 at 11:13 PM.
You will not get response until you upload your workbook, click on "Go Advanced" button then scroll down to find "Manage Attachments" text button to attach the file
Please try in D13 and fill down.Formula:Please Login or Register to view this content.
Dave
HI,
Thank you for that. Now I have an extension to that question, is it possible to do that if it was written as 'Twenty-Four' instead of '24'?
Thank you again.
Slightly different answer got this:
=INDEX(C2:C6,MATCH(1,--(A2:A6=A11)*(B2:B6=B11),0))
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)
Bookmarks