Excel - IF Function Problem - Expert Solution

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
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
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
User 29/09/2018 - 07:16
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
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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc