Apply conditional formatting for entire sheet based on the lookup values

Question

I have 2 sheets. The first one has 2 columns:

• A:A - sequential numbers from 1 to 100
• B:B - 1-5 value for each number in A

Another sheet has matrix 10x10 from 1 to 100 where I would like to make conditional formatting by defining by the value from Sheet1!B. For example on the Sheet2 there will be number 55. Then I need to go Sheet1, find value 55 in column A and then based on the value in column B decide what formatting to apply.

Answer 1

=VLOOKUP(D2, INDIRECT("Sheet2!A:B"), 2, 0)=5