I have a sheet with user ID's (users) sheet2, and an inventory sheet (PC Inv). I want to do the following; if any of the users IDs in sheet2 (users) column E (Primary Users), matches any user IDs in sheet1 (PC Inv), then copy contents of matching ID's row in sheet1(PC Inv) to sheet2 in the appropriate column in sheet2.Copy.xls
See if this is what you are looking for in F2:
The "1" is the column number from the first range
Please Login or Register to view this content.
If you found the solution to your question. Mark the thread as "Solved"
Thank everyone that helped you with a valid solution by clicking on their
There is no such thing as a problem, only a temporary lack of a solution
Another problem.....
In some cases the user ID exists multiple times in sheet 1. The first sollution you provided grabs only the first instance of that match and does not parse the rest that may exist. Any ideas? Thanks again!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks