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 C2 as BA11.
Also, in B2 of the tab, I want my argument function to respond blank if C2 reflects "With Sales; respond "Open" if the cell C2 reflects any other value from the index BA2:BA10 but if the cell C2 reflects value in BA11 which is "Check Received", I want my cell B2 to reflect "Closed". I figured if this would work good through multiple IFS function but its not really responding to my requirement. Can anyone please help?
1 Reply
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.
