Ok, so I have one sheet, and has a list of unique ID #s (Sheet 1, Column A), and a second worksheet within the same workbook that has Three lists of unique ID #s(sheet 2, Collumns B,C,and D).
What I would like to create, is a spot on Sheet 1, which searches all of Sheet 1, Collumn A, and compares it to Sheet 2, Collumns B,C,and D. If it finds a match, I want it to show up on Sheet 1, Collumn I.
How do I do this?
Thanks Much,
JT1561
Where you say, "I want it to show up on Sheet 1, Collumn I.", what do you mean by "it"? What do you want to show up?
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Basically, if it finds a match, say # 124921, Then I want it to Show that 124921 is a match, in cell I4.
Last edited by jt1561; 06-10-2013 at 09:10 PM.
I still need a little help with this if anybody has any ideas.
Still looking for a little help here.
Do you have a sample to share with us? That way we dont have to try and re=create what you already have
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Here is an example
thanks. Im out of time for now, I will take a look at it in a cpl of hours
Still trying to figure this one out
Hi
Not sure if this is what you want?
I gave each customer on Imortant sheet a range name, based omn the name at the top. Then in D3, use this...
=INDEX(Important!$A$1:$A$25,MATCH(Here!A6,INDIRECT(Here!D2),0),1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks