It seems like this topic has been beaten to death, but I still can't incorporate prior recommendations into my current project.
An additional dilemma is that I am a healthcare provider and cannot post my excel file for review due to conflicting patient health information.
I am trying to display the date that a given patient had their surgery if they fulfill an if function (results are tabulated as 0 or 1). Their surgery date is on one worksheet, and the other data point is on another worksheet. They both have in common the same medical record number on each respective worksheet.
Questions:
1.) Am I am able to use the index and match function across different worksheets? My match function worked perfectly(it serves as the row_number for my index function), but I am showing a #REF error and have localized it to my index function.
2.) For the purposes of the index function, does the [column_number] have to be within the same worksheet? And do I continue to reference it at "8" instead of "Sheet3!H:H"
I would like to thank you in advance for any help that you may be able to provide.
Bookmarks