I need a formula to pull the below information.
I have A1 and A2 in Excel 1 then B1 and B2 in Excel 2 which is exact match and I need to pull B3 as result in Excel 1 comparing these cells.
Eg: If I have Name and Class in Excel 1 and Name and Class in Excel 2 I need Marks to Excel 1 comparing both.
Please help
Solved by I. J. in 27 mins