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;
=IF(INDEX('[example.xlsx]sheet1'!F:F>0,"Yes","No"),MATCH(B8,'[example.xlsx]sheet1'!A:A,0))
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
=INDEX('[example.xlsx]sheet1'!F:F,MATCH(B8,'[example.xlsx]sheet1'!A:A,0))
- 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)?