• 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.

can some one help me with this

V

VSK

New Member
I have this file which has items held by employees from different locations. It will be different items , not necessarily the same. Each item will have a catalog number, description and qty

If one staff runs out of a particular item, how can he search the rest of the locations and find out who got it and the qty. Any one who has a qty more than Zero should show up in the list

there are other columns other than the cat no, description and qty, but those dont matter.

Can any one please help me with this

Regards
 

Attachments

Last edited by a moderator:
Hi ,

By having all of the data in one tab , by including one more column labelled Staff , the formula to do a lookup becomes so simple. By having multiple worksheets , an unnecessary level of complexity is being added.

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