Forum Discussion
Solved
Compare values in columns of different worksheet
Looking forward to do some checking between two excel files. I have a unique value in column A, I need to check if the values in column B, C, D, E & F is same in both the worksheets. Is there any po...
=VLOOKUP(A1,CHOOSE({1,2},sheet2!$A$1:$A$25,sheet2!$B$1:$B$25&sheet2!$C$1:$C$25&sheet2!$D$1:$D$25&sheet2!$E$1:$E$25&sheet2!$F$1:$F$25),2,FALSE)=B1&C1&D1&E1&F1Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
=VLOOKUP(sheet1!$A1,sheet2!$A$1:$F$20,COLUMN(sheet2!B:B),FALSE)=B1You can try this formula. I've entered the formula in cell H1 in sheet1 and copied it across range H1:L20. The result is either TRUE or FALSE (WAHR or FALSCH).
This is the data in sheet2:
Thanks...
I wish that I get the result checked, it should return true or false in column H based on the results of B,C,D,E,F.
I wish that I get the result checked, it should return true or false in column H based on the results of B,C,D,E,F.
=VLOOKUP(A1,CHOOSE({1,2},sheet2!$A$1:$A$25,sheet2!$B$1:$B$25&sheet2!$C$1:$C$25&sheet2!$D$1:$D$25&sheet2!$E$1:$E$25&sheet2!$F$1:$F$25),2,FALSE)=B1&C1&D1&E1&F1Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
- Thank you... it works.
Could you please help me in understanding the " CHOOSE({1,2}, " which is used in the formula... Appreciate if you could ....
Thank youExcel formula: Left lookup with VLOOKUP | Exceljet
In this link you can read an explanation of VLOOKUP with CHOOSE.