Hi everyone,
Can someone please help! I am in a work book with two sheets. I am trying to create a formula-
From sheet 2 in column XX I want it to pull from sheet 1 in the same work book
If there is a match in the two columns - a return of the same data from sheet one into sheet 2.
Thanks!
Formula that will return a matching value
Have a look at the VLOOKUP function.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
In general a VLOOKUP accomplishes something like that. =VLOOKUP (value, sheet that contains the value column it is in:column over you have to look to find the other value,number of that column,false ( meaning exact match))
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Thank you TMS
Thank you, I am having trouble writing the formula...but I am going to try againOriginally Posted by Sambo kid
If you upload a sample workbook, I'm sure we'll be able to provide more detailed and practical help.
Regards, TMS
Awesome, I will upload now, one minute
It is loading -
Upload.xlsx I am trying to match column M from the second sheet with column B from the first sheet names out of tolerance
IF anyone would like to take a stab at - I would be thankful!
Last edited by JT2015; 05-03-2015 at 05:27 PM.
OK, I am completely bemused by the file you have uploaded. I have no idea what you are trying to achieve.
It would help, I think, if you explained what sheet (by name, not Sheet1/Sheet2) and which cell (by column and row reference) will have the formula. Then what cell is being used as a lookup (by sheet/cell reference), which column is being searched (by sheet/column) and which data should be returned (by sheet/column).
Regards, TMS
for a start you'll need the names in both of those sheets to make a match. I don't see any of the names you have in column B in the area out of tolerance sheet in the qry new cp sheet in col M.
Thank you
Column M row 3 in the sheet New CP Master should have a formula that returns the same value if there is a match from Column D3 in sheet CP Master and the sheet Out of Tolerance Column B row 5
Sorry, I am so new at excel, please see my last postfor a start you'll need the names in both of those sheets to make a match. I don't see any of the names you have in column B in the area out of tolerance sheet in the qry new cp sheet in col M.
I think maybe we're looking at something like this:in cell M3 and copied down.Formula:
Please Login or Register to view this content.
Doesn't seem to add a lot of value. You could probably just use COUNTIF if you want to check if the Area Code is listed.
Regards, TMS
Last edited by TMS; 05-03-2015 at 07:03 PM. Reason: wrong cell reference n3 instead of M3
ok, both M3 and D3 in that sheet are blank. An example of a vlookup for you could be =vlooup(D3,' Area - Out of Tolerance'!B:B,1,FALSE). but again, I don't see anything to match against.
Thank you both so much! I have to leave for work, but I will get back on if it worked! Really appreciate your help
You rock it! It worked! Thanks TMS and Sambo kid!I think maybe we're looking at something like this:in cell n3 and copied down.Formula:Please Login or Register to view this content.
Doesn't seem to add a lot of value. You could probably just use COUNTIF if you want to check if the Area Code is listed.
Regards, TMS
Don't forget to mark your post as solved using thread tools drop down at the top of this thread. And you can thank those who've helped you by clicking add reputation under their post - that is how we advance on this forum.. I'm not sure i helped you but it appears TRevor did so he would probably appreciate it.
Absolutely!
You're welcome. Thanks for the rep.
I added columns now, can I just cut and paste and then add the new column and row?You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks