I am trying to do some sort of function to help me with my problem. I have two worksheets that both have the same columns of LOCATION and ITEM #. But each worksheet has a different amount of items. I have the ones I want in one of the worksheets, but I need to pull some information from the other worksheet. Is there a way to write a formula that would match up the LOCATION and ITEM # cells and then give me the information I need from that record? Any help is appreciated.
Last edited by zwickz711; 11-05-2008 at 01:10 PM.
Please take a few minutes to read the Forum Rules about thread titles, and then edit yours to make it descriptive of your problem.
Entia non sunt multiplicanda sine necessitate
any help at all would be appreciated
G'day
and welcome to the forum.
Click here for a suggested formula
Have I made you happy ??? If yes, please make me happy by pressing theAdd Reputation button in my post.
Please don't forget to do the same to other contributors of this forum.
ThanksI don't void confusion, I create it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks