How to make a check on the first excel file with a selection so that in the second in the cells the value changes from (by default) no to yes?

Question

SQL

Uploaded the database from the application to .csv - table format.
Divided into sheet (sheets) by type.
in another file created columns with the values ​​"Data validation" yes and no.
and also "Condittion formatting" value is equal to - so that the cells are painted over depending on the values.
Question:
how to make a check on the first file with a selection so that in the second one in the cells the value changes from (by default) no to yes ?
If there are sentences with SQL - prompt. I would appreciate any hint on a possible implementation.

Answer 1

how to do a check on the first file with a selection

=IF ( VLOOKUP="check", "yes", "no")
for macro or eng. language:
=IF ( VLOOKUP="test"; "yes"; "no")
Syntax and examples of VLOOKUP/VLOOKUP google
.
.
.
"Conditional Formatting"
Shl. the question is worded very crookedly. I still don't fully understand what you need.