Excel - report a value from another sheet

Question

Hello,&nbsp;I have an excel sheet with two tabs. First tab as those values :&nbsp;Tab 1Table | Question&nbsp;A1&nbsp; &nbsp; &nbsp;|&nbsp; Question XYZB2&nbsp; &nbsp; &nbsp;|&nbsp; Question ABCF7&nbsp; &nbsp; &nbsp; |&nbsp; Question MNP&nbsp;And I have another tab with one table number per line:&nbsp;Tab 2Table&nbsp; &nbsp; |&nbsp; Other info&nbsp; &nbsp;F7&nbsp; &nbsp; &nbsp; &nbsp;| ....B2&nbsp; &nbsp; &nbsp; &nbsp;| .....A1&nbsp; &nbsp; &nbsp; &nbsp;| .....&nbsp;I would like the question of Tab 1 to be reported automatically to a new column in Tab 2.&nbsp;Tab 2Table&nbsp; &nbsp; |&nbsp; Other info&nbsp; &nbsp;| Question of Tab 1 associated to table of first column of this tabF7&nbsp; &nbsp; &nbsp; &nbsp;| ....&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; Question MNPB2&nbsp; &nbsp; &nbsp; &nbsp;| .....&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp;Question ABC&nbsp;What would be the function ?&nbsp;Many thanks !&nbsp;

hansvogelaar · Answer

SophieBC&nbsp;
=XLOOKUP(A2, 'Tab 1'!A:A. 'Tab 1'!B:B, "")

sophiebc · Answer

HansVogelaar&nbsp;thank you !!

Forum Discussion

Excel - report a value from another sheet

Share

Resources