Forum Discussion
Index function and if function in an excel sheet
In my cell C2 of the sheet in tab 'SL Order Tracking' the index function is picking up dates from all functions except from AR2 even though it is defined through the Index function (BA2:BA11) in cell...
waqasahmed85 Your formula includes a reference to column AA, but you don't seem to have added a date in that column. Hence, the 9th status will be returned from the indexed range. Add a date in AA2 and the status will become Check Received.