TestSheet.xlsx
In the "database" sheet, there'll be two cells. One "ext[ension]" and the other "hall". I need the extension cell to reference the other sheets with regards to the data in the "hall" cell. So if the individual is in G103, I need the formula to extract that information from the proper sheet.
In every instance the data being extracted is exactly 1 cell away from the "hall" information cell, if that makes sense, as you can see in the testsheet attached.
As always I appreciate the help I get here. You guys rock.
Bookmarks