Vlookup across two different sheets

[Garrek]

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!

 

[Joe4]

Try something like this:

=IFERROR(VLOOKUP(A1,Active!A:D,4,0),VLOOKUP(A1,Inactive!A:D,4,0))

 

[BGY23]

hi joe,
I may be wrong but doesn't that formula need another "leg"? You have test, True but no false? Should it be , Vlookup(A1,Active!A:D,4,0) or am I in fat wrong

 

[Joe4]

I may be wrong but doesn't that formula need another "leg"? You have test, True but no false? Should it be , Vlookup(A1,Active!A:D,4,0) or am I in fat wrong

Note that it is the IFERROR function, not an IF function. IFERROR only has two arguments.
See: https://exceljet.net/excel-functions/excel-iferror-function

 

[BGY23]

Hi Joe, For years I've been doing Test, true,false with If(Iserror(. I'm gonna try this now. Glad I asked.Thanks

 

[Joe4]

Hi Joe, For years I've been doing Test, true,false with If(Iserror(. I'm gonna try this now. Glad I asked.Thanks

Yes, IFERROR is one of the "newer" functions (introduced with Excel 2007, I believe?), and is nice in that it replaces/shortens the old IF(ISERROR(... methodology.
I predict it will become your new best friend!