Sorry for the rough title, vlookup might not be the best solution here, but I don't know a better one (that's why I'm here!)
Basically I have values on two sheets, Active and Inactive. On the Active sheet, all values have "Active" In column D, and on the Inactive sheet, all values have "inactive" in column D (creative I know, that's how they're sorted though). In new sheets (Say Sheet3), these values are listed together in a table. How could I write a formula to populate their status (active/inactive) on new sheets? If it was all on one sheet this would be a simple vlookup, but because all the Actives are on one and all the Inactives are on another, I'm a little lost.
Sorry if this doesn't make sense, let me know if you need any clarity!
Basically I have values on two sheets, Active and Inactive. On the Active sheet, all values have "Active" In column D, and on the Inactive sheet, all values have "inactive" in column D (creative I know, that's how they're sorted though). In new sheets (Say Sheet3), these values are listed together in a table. How could I write a formula to populate their status (active/inactive) on new sheets? If it was all on one sheet this would be a simple vlookup, but because all the Actives are on one and all the Inactives are on another, I'm a little lost.
Sorry if this doesn't make sense, let me know if you need any clarity!