rduncan2019
New Member
- Joined
- Mar 4, 2019
- Messages
- 2
Hello,
Apologies if this has been asked before, I may not be using the best key words to search for. I have a form which has been filled out by people and the form responses are outputted to an excel file. I want to search this file for the entries made by specific people and at first thought of a vlookup to do it. However I do not know which column will contain the information and wanted a formula to search that would skip the blanks in the row and return the first entry it finds.
My data table is as such:
Column A - unique user ID to search on
Columns B to F - one of these columns, and only one of these, will contain an entry and I am looking for that entry to be returned; data is a text string
Thank you!
Apologies if this has been asked before, I may not be using the best key words to search for. I have a form which has been filled out by people and the form responses are outputted to an excel file. I want to search this file for the entries made by specific people and at first thought of a vlookup to do it. However I do not know which column will contain the information and wanted a formula to search that would skip the blanks in the row and return the first entry it finds.
My data table is as such:
Column A - unique user ID to search on
Columns B to F - one of these columns, and only one of these, will contain an entry and I am looking for that entry to be returned; data is a text string
Thank you!