I have the following formula in excel which works fine =INDEX(($B$3:$D$7,$B$11:$D$15,$B$19:$D$23),MATCH($F$5,$A$3:$A$7,0),MATCH(G$4,$B$2:$D$2,0),(IF(G$3="Unit Test",1,IF(G$3="Mid Term",2,3))))
But when I convert from excel to google sheets the formula does not work, it's the first section of the formula that is not working.
https://docs.google.com/spreadsheets...gid=1098820341
I hope the above link works and any input is greatly received.
Thank you
Please upload the Excel workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context and explain what the object of the formula is.
To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Copy of the excel version attached
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks