Matching a value with a specific category in another sheet

[Adamonia]

Hello everyone,

In the attached file you will find two scores on the Data! sheet: LOC.Score in column A and BAL.Score in column E. Each has their own sheet/tab at the bottom with their respective conversions.

On the Data! sheet, I would like to match the LOC.Score value in column A with it's respective LOC.Category found within the LOC! sheet. Column B provides the correct output.

The same is true for the BAL.Score, however, BAL.Score must consider gender as well. Thus, on the Data! sheet, I would like to match the BAL.Score value in column E with it's respective BAL.Category found on the BAL! sheet based on gender. Column F provides the correct output.

I feel like this is so simple, but I can't seem to figure it out. Any help you could provide would be greatly appreciated!

[oeldere]

add a column in sheet Bal =>BAL c2 =A2&B2 and drag down
`
Data!G2 =VLOOKUP(D2&E2,BAL!$C$1:$D$114,2,0) and drag down.

Add the file.

[Adamonia]

Thank you so much!! Based on your example I was able to adapt the formula for the LOC column as well!

=VLOOKUP(A2,LOC!$A$1:$B$48,2,0)

[oeldere]

Glad I could help.

If you are satisfied with the solution please mark the question solved.

You can add a reputation for the given answers by clicking on the star (add reputation) below your question.