Hi Team,
Need your help to find a formula.
I have a data in sheet 1 with numbers in column A and column B.. i have another data in sheet 2 in the same way..
I am trying to figure out a formula with which i can identify the data in Sheet 1 in sheet 2..
Example : - In sheet 1, row 1 has 197500 in column A and 100000001 in column B. I need to find out if the same numbers are available in sheet 2 in single row..
Sample data attached.. Please refer sheet 1 and sheet 2. Please help..
Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks
based on what you posted this should work... =IFERROR(IF(VLOOKUP(A3,Sheet1!A:A,1,FALSE)=A3,"Yes"),"No")
But you don't really say if you are including the Project ID in the mix.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Yes, Project ID is included.. If the combination of Emp ID and Project ID is repeated in sheet 2.. It should be called out in sheet 2 with "Yes"..Originally Posted by Sambo kid
Hi,
In Sheet 1, add the formula in col C
Formula:
Please Login or Register to view this content.
In Sheet 2,add the formula in col C
Formula:Please Login or Register to view this content.
this should work then, it is an array formula...
=IFERROR(IF(VLOOKUP(A3&B3,Sheet1!$A$3:$A$11&Sheet1!$B$3:$B$11,1,FALSE)=A3&B3,"Yes"),"No")
activate it by pressing ctrl+shift+enter so that the {} appear on both ends, you cannot add them, the three keys have to be pressed to activate it.
In Cell C3 of Sheet2 try
=IF(COUNTIFS(Sheet1!A:A,A3,Sheet1!B:B,B3),"Yes","No")
Copy down
Life's a spreadsheet, Excel!
Say thanks, Click *
@Aruin
Administrative note
Please update your profile '(post #2)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks