linking a Vllookup with 3 IFS?

[Weaselwithagun]

Hello,

On the attached example I have a data set, on another sheet I want to create a formula that pulls across the relevant result for each cell.

My original thought was to try and link 3 VLOOKUPS using IFS, so: IF the number is the same, and IF the month is the same and IF the colour is the same show the resulting cell value, but i'm not entering the syntax correctly or this can't be done this way

Does anyone know of a way of obtaining the results in a formula so that I could copy it across to all the cells in my results sheet and it would show correctly?

I.E. results sheet for number 3 in Nov for Green would say 4581.

Many thanks.

[The_Snook]

Hi Weaselwithagun,

I've tweaked your month data to unmerge the cells. Is the attached solution something you could work with?

Regards,

Snook