Hi everyone,
I am looking for suggestions around how to solve the following challenge.
Spreadsheet data validation:
tab 1) list of items with various columns, two of them being: column C has product id, column E has user id
tab 2) list of items with various columns, two of them being: column A has product id, column J has user id
I have two functions to identify:
1) tab 1> column C product-id value exists in tab 2> column A product-id column
=IF(ISERROR(VLOOKUP(C2,Export!$A$2:$A$1701,1,0)),"no","yes")
2) tab 1> column E user-id value exists in tab 2> column J user-id column
=IF(ISERROR(VLOOKUP(E2,Export!$J$2:$J$1701,1,0)),"no","yes")
However, what i really want to do is the following:
1) is the record in tab 1> product-id belonging to tab 1> user-id also found in tab 2?
My functions above only tell me that the records exist, they dont tell me whether the records of user+product in tab 1 is also found in tab 2.
Tab 2 data comes from a different application, that's why i need to identify inconsistencies in tab 2.
I hope this makes sense and clarifies what i am trying to do.
I would consider myself a newbie writing functions in Excel, so your advice around how to go about doing this will be very appreciated.
I would also prefer to stick to functions rather than writing VB
Thanks
Vane
Bookmarks