I'm trying to combine info from two speadsheets using VLOOKUP. I need to have excel look at a cell, compare to another, and if it matches bring over the value. If it doesn't match, I want it to come back with text that reads "Open".
I'm trying to combine info from two speadsheets using VLOOKUP. I need to have excel look at a cell, compare to another, and if it matches bring over the value. If it doesn't match, I want it to come back with text that reads "Open".
You could put it inside an IF statement. IF(ISERROR(VLOOKUP(a,b,c)),"OPEN",VLOOKUP(a,b,c))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks