xlsread returns empty when reading a cell with a formula

using command below I get num as an empty array when the cell has a formula. how to get the value returned from Excel formula in the cell back into MATLAB: num = xlsread('h&vlookup_if_and_or_Capacity_Planning.xlsx','Sheet1','B26','basic')

Answer 1

[Azzi Abdelmalek]

[num,text,both] = xlsread('h&vlookup_if_and_or_Capacity_Planning.xlsx','Sheet1','B26','basic')