bruce24444
New Member
- Joined
- Feb 15, 2010
- Messages
- 40
- Office Version
- 365
- 2019
- Platform
- Windows
I have a worksheet to which I import data from (2) separate data sources to.
One imports to MS_Data (table) and the other to XA_Data (table). I then have a 3rd sheet with an IC_List (table) which takes data from each of the data set and combines it into a single worksheet.
If the item number exists in both MS_Data and XA_Data, I want the IC_List to indicate "Yes" or "No"
This is the formula I've been working with but it equals No all the time
=IF(ISERROR(VLOOKUP([@[Item Number]],XA_Data[Item '#],1,FALSE)),"No","Yes")
[@[Item Number]] =MS_Data!A4 and so on
One imports to MS_Data (table) and the other to XA_Data (table). I then have a 3rd sheet with an IC_List (table) which takes data from each of the data set and combines it into a single worksheet.
If the item number exists in both MS_Data and XA_Data, I want the IC_List to indicate "Yes" or "No"
This is the formula I've been working with but it equals No all the time
=IF(ISERROR(VLOOKUP([@[Item Number]],XA_Data[Item '#],1,FALSE)),"No","Yes")
[@[Item Number]] =MS_Data!A4 and so on