Excel Formula

chandu

New member
Joined
Aug 9, 2018
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2010
I have a scenario in a excel file with 3 sheets, Now I need to get information into sheet 1 from a condition which should satisfy between sheet 2 and sheet 3, The logic is If data in sheet 2 column A matches with data in Sheet 3 column I then it should display the sheet 3 column D data in the Sheet 1 Column A. Can someone help me out on this?
 
Please change your title to explain your problem. Almost everybody here wants help with an Excel formula!!!
 
.
This is one way :

Paste this formula in Sheet 1, A1 .... then drag down Column A as far as required.

Code:
=IF(Sheet2!A1=Sheet3!I1,Sheet3!D1,"")
 
Back
Top