I have to sheet.
Sheet1 with list of values in Column A
Sheet 2 has Value range as below
Sheet1:
COLA
1
3
4
6
8
Sheet2
COLA COLB
1
2
3 7
How do I do vlookup which will tell me all matching and non matching values from Sheet 1 and sheet 2 on both side ?
Sheet1 with list of values in Column A
Sheet 2 has Value range as below
Sheet1:
COLA
1
3
4
6
8
Sheet2
COLA COLB
1
2
3 7
How do I do vlookup which will tell me all matching and non matching values from Sheet 1 and sheet 2 on both side ?