• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

counting totals

C

chuckab2

New Member
This formula would be used to track inventory which changes every month. The part number and the totals are always in the same column but not in the same row every month.

I would like to have a formula that looks for a numerical value "part number" which is located in one column then if it finds that part number, looks in the next column where the quantity is stored; then takes that quantity and shows it on a different sheet.
 

Attachments

You just need a VLOOKUP formula - see file.

I made your Parts Qty list into an Excel Table - I prefer that as if you add any parts, the formula will still work ...
 

Attachments

David Evans said:
You just need a VLOOKUP formula - see file.

I made your Parts Qty list into an Excel Table - I prefer that as if you add any parts, the formula will still work ...
Click to expand...

Thank you so much for responding. I'm still having some trouble; I attached a better version of what the spreadsheet looks like. The "Item" tab is where the particular data that I'm trying to get at is located. The "more data" tabs are sheets of other data. I'm consolidating the totals on the "Stage" tab" Can I use the NSN as an identifier and draw the total from there? I tried using the vlookup formula that you showed me but was unsuccessful.

I'd post the entire workbook but it has some sensitive material on it, don't want to lose my job by posting classified material LOL.
 

Attachments

Hi ,

Have you tried this formula :

=VLOOKUP(A3,Table1[[NSN]:[Total ]],2,FALSE)

I assume you wish to return the values in the Total column.

Narayan
 
You must log in or register to reply here.
Back
Top