Hey everyone! It seems that my formula isn't returning all the values for my unmanaged sheet... it finds a lot but while checking through the list, it seems that a few have been returned as "unaccounted for" when I've found the in the unmanaged sheet. The formatting seems to all be the same as well. Any ideas why? Below is the formula that I have:

=IF(ISERROR(VLOOKUP(A3,Orion!A:B,2,FALSE)),IF(ISERROR(VLOOKUP(A3,LMS!A:B,2,FALSE)),IFERROR(VLOOKUP(A3,Unmanaged!A:B,2,FALSE),"Unaccounted For"),VLOOKUP(A3,LMS!A:B,2,FALSE)),VLOOKUP(A3,Orion!A:B,2,FALSE))

Hi,

I tested your formula and that works correct. So my guess would be that the lookup value that you use to look up doesn't match the value in your lookup table array. Have you checked the values you are looking up?

Maurice

Yep, I'd go in the same direction: You may could use formulas like TRIM() in order to delete the blanks from the values.