Forum Discussion
Solved
excel
Hello. I Wanted to find a way to solve this and would appreciate all the help. here I have two columns in different sheets and i want to put them in one sheet correspondingly. the thing is when i ...
=IFERROR(INDEX(Tabelle2!$A$1:$A$10,SMALL(ROW(Tabelle2!$A$1:$A$10),A1)),"")Does this return the expected result? Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
=IF(A1="","",VLOOKUP(A1,Sheet2!A1:A10,1,0))
This worked thank u so much^^