randomhause
New Member
- Joined
- Jun 12, 2015
- Messages
- 8
Hello kind strangers ~ I need some help with the following scenario in Excel...
There are two lists in separate workbooks that need to be compared, Master List and Sample List.
The rows in the Master List need to be matched exactly to the Sample List, which has more rows but same number of columns.
So row A2 in Master List needs to be searched for in the Sample List workbook. Ideally would like to have a function that will return a "N/a" if a Master List row doesn't appear in the Sample List and a "Matched" if it does.
Details about both lists:
Master List - A2:G2, 1240 Rows
Sample List - A2:G2, 1353 Rows
<tbody>
</tbody>
Limitations:
I cannot go row by row because the rows in the Sample list are not in order (but the columns are). For example:
<tbody>
</tbody>
<tbody>
</tbody>
Also, I don't need to join the data as Sample List includes additional rows. I just need to verify that the information in Master List does appear in the Sample List.
What I have tried:
I Appreciate Your Time In Helping Me
There are two lists in separate workbooks that need to be compared, Master List and Sample List.
The rows in the Master List need to be matched exactly to the Sample List, which has more rows but same number of columns.
So row A2 in Master List needs to be searched for in the Sample List workbook. Ideally would like to have a function that will return a "N/a" if a Master List row doesn't appear in the Sample List and a "Matched" if it does.
Details about both lists:
Master List - A2:G2, 1240 Rows
Sample List - A2:G2, 1353 Rows
Year | Term | Session | Event | Section | Name | Credits |
#### | AAA | BBB | CC#### | D## | EEEE | #.## |
<tbody>
</tbody>
Limitations:
I cannot go row by row because the rows in the Sample list are not in order (but the columns are). For example:
Master List | |||||||
A1 | Year | Term | Session | Event | Section | Name | Credits |
A2 | 2015 | Fall | First | ACC8500 | A01 | Generic Name | 0.75 |
A3 | 2016 | Spring | Full | MKT7500 | 01 | Generic Name Two | 1 |
<tbody>
</tbody>
Sample List | |||||||
A1 | Year | Term | Session | Event | Section | Name | Credits |
A2 | 2016 | Spring | Full | MKT7500 | 01 | Generic NameTwo | 1 |
A3 | 2015 | Fall | First | ACC8500 | A01 | Generic Name | 0.75 |
<tbody>
</tbody>
Also, I don't need to join the data as Sample List includes additional rows. I just need to verify that the information in Master List does appear in the Sample List.
What I have tried:
- On Simple List H2=MATCH(A2:G2,'[MasterList.xlsx]Sheet1'!$A$2:$G$1243,0)
- This returns "#VALUE" because of the cells that have different data types (text and numeric values).
- A variation of =VLOOKUP(A2,[MasterList.xlsx]Sheet1!$A$2:$G$1353,1,0)
- however doesn't work as in the Sample list the information is not organized the same.
I Appreciate Your Time In Helping Me
Last edited: