How to use conditional formatting with vlookup and with Indirect in a Google Sheet
How to use conditional formatting with VLOOKUP and with Indirect in a Google Sheet.
If you like this video, you can click on "Like", share it and subscribe to our channel:
https://www.youtube.com/user/tamirkor...
If this video helped you, please consider a one time contribution to support new content on this channel: https://paypal.me/TAMIRKO
Here's the link to the Google Sheet which was used in this video
(There's no need to ask for permission. Just create a duplicate of it by using File -- Make a copy):
https://docs.google.com/spreadsheets/...
The above Google Sheet is in a read-only format, so click on "File : Make a copy" and then you'll have your own version of it which you can use freely.
And here's the function that I used for the conditional formatting:
=VLOOKUP(D7,indirect("All brands list!$B$2:$V$190"),21,FALSE)="YES"
Btw, do you want to learn how to solve a Rubik's cube 3 X 3 with new techniques and faster algorithms ? - Click on this link: • How to solve a Rubik's cube 3 X 3 - N...