Forum Discussion
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...
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' ?
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.
