Question description:
This user has given permission to use the problem statement for this
blog.
I have two tables T1 and T2, values in one column of T1 matches with values of One column in T2 . I have used count if to find no.of cells that matches the criteria. I need to extract the entire data of that row in T2 which matched the criteria
Solved by I. D. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
29/09/2018 - 06:48
hi
User
29/09/2018 - 06:49
i need help with excel
[Uploaded an Excel file]
Excelchat Expert
29/09/2018 - 06:49
Welcome to Excelchat, I see that your question is about Formulas.
Excelchat Expert
29/09/2018 - 06:49
I can help you with that problem, I'll be able to give you a solution and an explanation. Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
Excelchat Expert
29/09/2018 - 06:49
Let me ask you a couple of quick questions to make sure I fully understand your problem.
User
29/09/2018 - 06:49
okay
Excelchat Expert
29/09/2018 - 06:50
Based on what you've shared, you need to extract the entire data of a column that matched the criteria.
User
29/09/2018 - 06:51
i have uploaded an spread sheet
Excelchat Expert
29/09/2018 - 06:51
Yes I downloaded the data, can you specify the sheet and cells I should be looking at?
User
29/09/2018 - 06:51
the sheet name is land specs
Excelchat Expert
29/09/2018 - 06:53
ok which column you want to extract data from and where should we placed the extracted data and the criteria?
User
29/09/2018 - 06:53
the column is K in the first table which should match the column F in the table below it
User
29/09/2018 - 06:55
K7:K27 is the reference column
Excelchat Expert
29/09/2018 - 06:56
Ok just to make sure I understand it correctly, what should match in K7 cell?
User
29/09/2018 - 06:56
the values in coulmn F31:f41
Excelchat Expert
29/09/2018 - 06:57
You need the formula in column N?
User
29/09/2018 - 06:58
I need the formula to extract the row data of the matched column
Excelchat Expert
29/09/2018 - 06:59
Ok I'm going to create the formula needed to get the output you want. This should take me less than 20 minutes. If we need more than 20 minutes, you'll be able to extend the session up to 60 total minutes.
Excelchat Expert
29/09/2018 - 06:59
I'll be working on a local file. When I'm done, I will share the updated file here and you can download it on your end.
Excelchat Expert
29/09/2018 - 06:59
I’m working on your solution. But don’t worry, I’ll be updating you throughout!
User
29/09/2018 - 07:00
for example for the criteria is the value in k7 . It matched with the values in coulmns F31, F34, I need the entire row details of F31 ie A31:H31
User
29/09/2018 - 07:00
thank you
Excelchat Expert
29/09/2018 - 07:01
ok got it, thanks for the example
User
29/09/2018 - 07:06
i can send you the latest version of the workbook which is in macro free
Excelchat Expert
29/09/2018 - 07:07
sure, but just to make sure you need the formula to start from column N?
User
29/09/2018 - 07:08
I have sent you the latest updated sheet
[Uploaded an Excel file]
User
29/09/2018 - 07:09
you can place the results at anywhere may be at the bottom of the sheet like an another table
Excelchat Expert
29/09/2018 - 07:13
I'm still working, I should have your solution soon.
User
29/09/2018 - 07:14
okay im sure you understood my question
Excelchat Expert
29/09/2018 - 07:15
Yes, I need to match K7 (>=) with data in F31:F41 and return the row that matched the criteria (A:H)
User
29/09/2018 - 07:16
yes
User
29/09/2018 - 07:16
perfect
User
29/09/2018 - 07:17
so that i can do for the rest of the Columns From K8
User
29/09/2018 - 07:17
i would be really thankful for you
Excelchat Expert
29/09/2018 - 07:18
Sure, I'm happy to help.
Excelchat Expert
29/09/2018 - 07:24
Hello, do you need to return all rows that match? so this is not 1 is to 1 lookup?
User
29/09/2018 - 07:24
yes
Excelchat Expert
29/09/2018 - 07:25
Ok I'm still working on a formula, this may take some time. Thanks for your patience.
User
29/09/2018 - 07:26
cheers i have been working on this for some time since i have very basic knowledge i couldn't work it out
Excelchat Expert
29/09/2018 - 07:27
Yeah this is a complex formula that we have to come up with
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.