Formula to compare (2) formatted table

[bruce24444]

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

 

[Zot]

Click XL2BB icon
Install the add-in
Use it to copy and paste your table or mock-up table so that helpers here can see how your table structure looks like. You will get response faster that way.

 

[bruce24444]

Thanks for the response Zot, but I figured it out
=IF(COUNTIF(XA_Data[Claim '#],[@Claim])=0, "No", "Yes")