Hi All,
I have two separate workbooks, and I need to check all the values in WB1, Sheet1, Column C to see if they are anywhere in WB2.
I thought this might be a bit of a big ask, so I've created a helper sheet in WB2 that has columns A:L with column headers and the values I'm looking for in A2:L50
I then thought it would be a relatively simple INDEX MATCH type thing to look for the values in WB1 Col C, and then if it's found in column D, return D1. But I can't now think how to do it without some kind of searching macro (not ideal, have to get special permission from IT for this!), or using a lot of nested IFs (again not ideal because WB1 is already massive and I fear this might break it). I'm sure there should be a really simple solution, but I just can't find it today.
Can you help?
I have two separate workbooks, and I need to check all the values in WB1, Sheet1, Column C to see if they are anywhere in WB2.
I thought this might be a bit of a big ask, so I've created a helper sheet in WB2 that has columns A:L with column headers and the values I'm looking for in A2:L50
I then thought it would be a relatively simple INDEX MATCH type thing to look for the values in WB1 Col C, and then if it's found in column D, return D1. But I can't now think how to do it without some kind of searching macro (not ideal, have to get special permission from IT for this!), or using a lot of nested IFs (again not ideal because WB1 is already massive and I fear this might break it). I'm sure there should be a really simple solution, but I just can't find it today.
Can you help?
