Hi there,
Sorry for the late reply, and not sure if you still need help with this. if you do, it might be helpful to upload a sample workbook for us. (Just click Go Advanced, and you can do so.)
i have a set of data
now i want excel to look up value 12345 from table 1 search table 2
and return with entire column
thus now making a table with 5 cloumns
and matched correspondingly how do i do that1 want
12345 1/2/2011 4/2/2011 12567 2/25/2011 3/20/2011 1257 3/20/2011 4/20/2011
12345 1/23/2011 12567 2/25/2011 3456 3/5/2011
Hi there,
Sorry for the late reply, and not sure if you still need help with this. if you do, it might be helpful to upload a sample workbook for us. (Just click Go Advanced, and you can do so.)
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book Master Your Data for Excel and Power BI, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
here is a sample i have to combine sheet 1 and 2
what ever method i use it looks up the first column of data and ignores the rest
I need a clarification on this, as per your sheet, you want to lookup the values in Column A which would return the values in the entire Corresponding row is it ?? Can you please describe this better ?
Yes i want to merge all values corresponding to A into single column
I'm still not quite following this either.
Can you product a sheet that shows us what the expected output will look like from what you've already given us?
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book Master Your Data for Excel and Power BI, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
sure this is the way i want the result
i have a pivot table of sheet 2 can i merge it with normal table of sheet 1
or can i merge 2 pivot table
Sorry, so in the example file, you have sheet 1 and sheet 2... you want to copy all the data from sheet 2 and append it to the data table in sheet 1, is that correct?
Sheet 2's data is in a pivot table... is sheet 1's data as well, or is it just a range of data, and not a formal table?
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book Master Your Data for Excel and Power BI, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
yes ur right sheet 2 is a pivot table sheet 1 is a normal table
Bookmarks