I have searched the forum for a couple of hours looking for what seems to me should be a simple formula but can't find anything similar, so I'm asking here. Please help me!
I want to return "Active" or "Inactive" based on whether or not a number in column A on one sheet matches column A on another sheet. I have tried several things based on what you have helped me with in the past but it's not working. Here is what I am trying -
IF(VLOOKUP(A:A,HOME!A:A,1,0),"Inactive","Active")
where A:A is the column on the current sheet, and HOME is the other sheet. This returns an #N/A error in every cell, even when the numbers match. If I use a single quote around 'HOME!', it tells me there is an error in the formula.
I'm sure this is a piece of cake for you gurus out there. I am trying to learn Excel on my own as I can't afford classes. I have gone to YouTube and learned alot but I'm not sure if I'm even using the right Excel formula. Should I be using MATCH or something else instead of VLOOKUP?
Thank you in advance!![]()
Bookmarks