CODEWITHSUNDEEP
if-statementgoogle-sheetsexcel-formula
Data Prospector
Data Prospector

Reputation: 27

IF Statement to return a value based on two cells in sheets/excel with colour formatting

Hi I'm struggling with the correct IF statement to look at the impact and effort columns and assign the correct category Value with colour which I will need to copy through a massive list. Just cant seem to get it right and on a couple of deadlines.

Example Snip

Upvotes: 1

Views: 79

Answers (1)

player0
player0

Reputation: 1

use in C2:

=INDEX(IFNA(VLOOKUP(A2:A&B2:B, {F2:F&E2:E, G2:G}, 2, 0)))

Upvotes: 1

Related Questions