Forum Discussion
Importing data from another sheet based on condition
Hello all, I need help with importing data to sheet 1 from sheet 2. sheet 1 has name, name of work, date and bill number (name and name of work are empty) sheet 2 has name, name of work, dat...
=INDEX(sheet1!$D$2:$D$9,MATCH(1,(sheet2!E2=sheet1!$A$2:$A$9)*(sheet2!F2=sheet1!$B$2:$B$9),0))You can try INDEX and MATCH. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
Thank you for trying to help.
when I put the formula in first cell of column where i want the names to be imported and hit enter, it just shows 0.
is there anyway you can help. thank you
=VLOOKUP(E2&F2,CHOOSE({1,2},sheet1!$A$2:$A$9&sheet1!$B$2:$B$9,sheet1!$D$2:$D$9),2,FALSE)You can as well apply the above formula. You have to enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
What Excel version do you work with? If you don't work with Office365 or 2021 the formula doesn't work if you only hit enter instead of hitting ctrl+shift+enter.
However if you work with Office365 you can as well apply XLOOKUP instead of INDEX and MATCH or VLOOKUP.