Forum Discussion
Beth Stirling
Nov 22, 2017Copper Contributor
Formula Help for Vlookup and IF
Hello,
Im in need of help.
I have a worksheet with three tabs. Tab A is my working tab. I need to perform a VLOOKUP/IF Formula to find a work task 'Maths' for example in a Column B, i...
Detlef_Lewin
Nov 23, 2017Silver Contributor
Beth,
what is the problem? It's a simple lookup.
=LOOKUP("Maths",'C'!$B:$Z,COLUMNS(B1),0)