Forum Discussion
Return one cell data in a second cell based on a third cell
Hi, I'm pretty sure this is a simple thing to do but I've been unable to find the answer via my internet searching so far. I have a holiday leave sheet whereby column A shows the day leave is book...
For such your sample
To avoid errors I'd recommend in column B use
=C4and apply custom format "dddd"
In F4 formula could be
=IFNA(INDEX($I$3:$I$7,MATCH(TEXT($C4,"dddd"),$H$3:$H$7,0)),"")and drag it down. Sample file is attached.