Ok I have wasted about 6 hours googling this and I cannot find a solution. It seems like it should be simple but I can't get my head around this.
- Imagine 2 worksheets "Data" and "Form"
- "Data" has 6 columns of data
- the cells in all 5 of these column have different values or may be blank. There are no duplicates other than blank cells.
- I cannot rework the columns in the "Data" they need to remain as is.
- From the "form" sheet I want to look up a single value
What I am trying to do is look for a single value in RunID columns 2,3,4,5 on the "Data" sheet and return the match in column 1 Run # to be displayed in the "Form" sheet.
The RunID entered on the Form is not always the entire value as it appears in the RunID columns on the "Data" sheet.
I tried a couple array versions of Index Match but those were not getting me what I needed and also the array formula, for some reason, was not staying an array.
Hope that makes sense.
Gray.
Bookmarks