I have a master sheet which pulls data from another workbook.
the workbook is called example.xlsx. This workbook has multiple sheets inside of it.
In this Master sheet I have created the formula below;
I get a #VALUE error.
B8 = master sheet = name of a person F:F = example.xlsx = is a column of numbers ranging from 0 - 9+ A:A = example.xlsx = a list of names.
original formula before i used IF
- this will bring back a value of 29
Can anyone point me in the right direction please so that instead of 29, it will show a Yes or No based on t is greater than a number(5)?