Forum Discussion
AshleighCrighton
Nov 28, 2023Copper Contributor
Formula to find data based on information in two different columns
I'm struggling to find the correct formula to get me the data as below:. I have column A, B and C. Column A has a persons name, Column B has an address, and Column C has a specific size. Bas...
HansVogelaar
Dec 05, 2023MVP
The formulas use the name in A1. If you enter another name in A1, the formulas will automatically display the results for that name.
So you could create copies of the sheet, and change the name in A1.
AshleighCrighton
Dec 11, 2023Copper Contributor
Hi Hans,
For some reason I still can't get it to work? If I add another 'Jacob' to the dump sheet, with details, it won't add on to the 'Jacob' sheet?
I'm thinking it may be easier to make 2x dump sheets to separate off the 1/28's and the FP/HP? so we don't have to pull through that data within the formula?
Is this possible? I can upload a sample if helpful?
For some reason I still can't get it to work? If I add another 'Jacob' to the dump sheet, with details, it won't add on to the 'Jacob' sheet?
I'm thinking it may be easier to make 2x dump sheets to separate off the 1/28's and the FP/HP? so we don't have to pull through that data within the formula?
Is this possible? I can upload a sample if helpful?
- HansVogelaarDec 11, 2023MVP
See the attached workbook. If you add a new row to the DUMP sheet with Grant, Jacob or John in column A, the new data will automatically be added to the corresponding worksheet.
- peiyezhuDec 11, 2023Bronze Contributormy 'sheet two' ?
Sorry,I can not understand what you need.
Can you share your expected result according to your source table? - AshleighCrightonDec 11, 2023Copper ContributorI may have explained this badly..
I'm thinking instead, if I can identify the name from column A, and have the formula auto enter the address from column B in my 'sheet two' ?