Hi Everyone.
I've been searching and can't seem to find a formula that does a vlookup from one sheet to another and replaces the actual (true value) responses with "X", and a blank with a blank (Not "#N/A).
I've tried this (see dashboard cell: C4:D4), but it gives me the result as the value, not X. And a blank as "0": =IF(A4="","",IF(ISERROR(VLOOKUP(A4,'Completed Skills'!A:C,3,0)),REPT("X",1),VLOOKUP(Dashboard!A4,'Completed Skills'!A:C,3,0)))
I also tried this (see dashboard cell: C5:D5), but it only gives me "X" as the result =IF(ISERROR(VLOOKUP(A5,'Completed Skills'!A:C,3,0))," ",REPT("X",1))
The response I'm looking to replace is "Completed" with "X" and blank with blank
Attached is a workbook with both pages if that helps to clarify.
Oh, and if this is simpler with match/index, I'm open to exploring that, but i've never used it.
Oh, and bonus points for if you can populate A4:A23 automatically on the "Dashboard" when we filter column "A" on the "Completed Skills" page
I know that's a lot, if you have any questions or would like some clarity, please let me know.
I think we're close, but just not quite there. Any help is much appreciated.
HHmmmm??
Thanks everyone!
Bookmarks