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...
Hi Hans,
Thanks so much. I'm stuck on the copying from another sheet part.. I have the sheet with all the data on it called 'DUMP', however struggling to figure out how to get the formula to pick up this is the sheet?
This is what I have changed it to =XLOOKUP(A2&C2, 'DUMP'!$A$2:$A$1000&'DUMP'!$C$2:$C$1000, "")
Thanks so much. I'm stuck on the copying from another sheet part.. I have the sheet with all the data on it called 'DUMP', however struggling to figure out how to get the formula to pick up this is the sheet?
This is what I have changed it to =XLOOKUP(A2&C2, 'DUMP'!$A$2:$A$1000&'DUMP'!$C$2:$C$1000, "")
Does it work? If not, could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- I have just uploaded to the original post 'Sample' 🙂
You can see the DUMP tab, has the informaiton given, and it needs to pull the address over to two parts of the document Tab BI think I completely misunderstood your question. Does the attached version do what you want?
- Oh my gosh it DOES! Thanks Hans,
However my now issue is that I have about 10x pages of different names that I need the formula to work for (Jacob was one, however I have booking forms for more people).
How can I adjust the filter to work for each name?