Assigning multiple values as an IF function

[angeloudaki]

Ok, not sure if I am asking way too much of Excel here.

If I have 50 numbers, each of which are assigned a date e.g.

1	31-Dec-18
2	07-Jan-19
3	14-Jan-19
4	21-Jan-19
5	28-Jan-19
6	04-Feb-19

<colgroup><col><col></colgroup><tbody>
</tbody>

And I have a table/dataset in another tab where the numbers are assigned to a row (100+ persons) at random, how do I ask Excel to display the corresponding date?

I was thinking an IF command; but can't find the right one...

 

[Fluff]

Have a look at Vlookup https://exceljet.net/excel-functions/excel-vlookup-function