I have a table, it’s basically a reporting table. It’s a subset of another table.
I want to search the name in my subset, then find it in the main table and find the value for a certain thing.
Subset
| Name | Attendance |
|---|---|
| Eoin | Unknown |
| Peter | Unknown |
Main dataset
| Name | Age | Attendance |
|---|---|---|
| Eoin | 21 | 4 |
| Paul | 42 | 12 |
| Mary | 13 | 1 |
| Peter | 99 | 0 |
What I want to do is to get the attendance in the main dataset and enter it into my subset (marked unknown in my example).
I have done a VLookup but it’s returning 1 which is not the right value.
=VLOOKUP(A2,'Traffic Lights'!D3:Q35,5,FALSE)
- A2 is the name in the subset.
- Traffic Lights D3:D3 is the data in
another sheet in the same workbook. - 5 is the column number in the other worksheet.
- FALSE I didn’t really know what to use. But the other worksheet is not sorted in any way. The first column is the names of the people.
