Needed help on Excel formulae

[excelformulae]

Hi sir/Madam,

I am really struggling to compare and display the values in excel.

My requirement: I have excel sheet with two tabs. First tab has two columns A and B. A is having values of incident id and B is having corresponding dates. In same way Second tab also has two columns A and B . A is having values of incident id and B is having corresponding dates. Some values of column A of first tab has matches in second tab column A. So I want to display those matched values of Column A of first and second tabs and their (column A's) corresponding values from column B of both tabs in separate tab in the format as below table. I have highlighted I have attached excel spreadsheet. I am really in need of this. It would be appreciated if someone help me on this. Thanks in advance

Expected sample result:-

Display values common in Column A of First and second tabs (Highlighted in yellow)	Display the column A’s corresponding value in column B of First tab (Highlighted in yellow)	Display the column A’s corresponding value in column B of Second tab (Highlighted in yellow)
INC000018208304	4/30/2018 16:30	5/1/18 2:00
INC000018208291	4/30/2018 16:24	5/1/18 1:54

<tbody>
</tbody>

 

[excelformulae]

Hi Aladin,

The expected output that I have shared is for you to understand how the output will appear. So manually, I have updated 19 rows in expected out put. To update remaining rows manually, it would take lot of time for me, becoz it is manual work. Please let me know if you really want all the common items to be updated in expected output?

 

[Aladin Akyurek]

Hi Aladin,

The expected output that I have shared is for you to understand how the output will appear. So manually, I have updated 19 rows in expected out put. To update remaining rows manually, it would take lot of time for me, becoz it is manual work. Please let me know if you really want all the common items to be updated in expected output?

No.

In A2 of Sheet3 control+shift+enter, nor just enter, and copy down:

=IFERROR(INDEX(Sheet1!$A$1:$A$295,SMALL(IF(ISNUMBER(MATCH(Sheet1!$A$1:$A$295,Sheet2!$A$1:$A$172,0)),ROW(Sheet1!$A$1:$A$295)-ROW(Sheet1!$A$1)+1),ROWS($A$2:A2))),"")

In B2 of Sheet3 just enter and copy down:

IF($B2="","",VLOOKUP($A2,Sheet2!$A:$B,2,0))

In C2 of Sheet3 just enter and copy down:

=IF($B2="","",VLOOKUP($A2,Sheet2!$A:$B,2,0))

 

[excelformulae]

No.

In A2 of Sheet3 control+shift+enter, nor just enter, and copy down:

=IFERROR(INDEX(Sheet1!$A$1:$A$295,SMALL(IF(ISNUMBER(MATCH(Sheet1!$A$1:$A$295,Sheet2!$A$1:$A$172,0)),ROW(Sheet1!$A$1:$A$295)-ROW(Sheet1!$A$1)+1),ROWS($A$2:A2))),"")

In B2 of Sheet3 just enter and copy down:

IF($B2="","",VLOOKUP($A2,Sheet2!$A:$B,2,0))

In C2 of Sheet3 just enter and copy down:

=IF($B2="","",VLOOKUP($A2,Sheet2!$A:$B,2,0))

The above formula is not working for me. I am inserting an image of excel screenshot.

 

[Aladin Akyurek]

The above formula is not working for me. I am inserting an image of excel screenshot.

Just "not working for me" is not informative. And I'm s

orry, I don't want any image which is not readable into Excel.​

By the way, control+shift+enter means: Press down the control and the shift keys at the same time while you hit the enter key. When done successfully, Excel itself puts a pair of { and } around the formula in recognition.

Still in doubt, create small input samples (not more than 10 records) and the output which must obtain from those input samples.