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...
AshleighCrighton
Copper Contributor
I 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' ?
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' ?
peiyezhu
Dec 11, 2023Bronze Contributor
my 'sheet two' ?
Sorry,I can not understand what you need.
Can you share your expected result according to your source table?
Sorry,I can not understand what you need.
Can you share your expected result according to your source table?