Countifs, Sumifs, is there another "ifs"?

[Eldernurf]

I learned how to use countifs and sumifs, but I don't need to count or sum based on many criteria, I just need to know the text in a cell of a table based on many criteria of that table. Is that clear?

For example, if I have these columns for my table:

Date / Work Shift / Code / Sector


And I need to find the code based on the Date, Work Shift and Sector, how can I do it. There are more complications regarding the fact that the date isn't organized, and codes aren't unique (the same can show up on many days and shifts).

Thank you already, guys;

[cheeze83]

you say there is many criteria, what is the criteria? There are a couple of different ways I can think of doing it, but I cant start to put an answer together on what you've given - do you have a sample sheet can look at?

[daddylonglegs]

You can use a LOOKUP formula, e.g.

=LOOKUP(2,1/(Date=Z2)/(Work_shift=Z3)/(Sector=Z4),Code)

where Z2:Z4 contain the criteria

[Eldernurf]

Here is a sample, with the SOURCE and the Worksheet.