Forum Discussion
Rudrabhadra
Aug 08, 2022Brass Contributor
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...
Rudrabhadra
Aug 08, 2022Brass Contributor
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.
OliverScheurich
Aug 08, 2022Gold Contributor
=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&F1
Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
- RudrabhadraAug 09, 2022Brass ContributorThank 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 you- OliverScheurichAug 09, 2022Gold Contributor
Excel formula: Left lookup with VLOOKUP | Exceljet
In this link you can read an explanation of VLOOKUP with CHOOSE.