Try..in C2
=IF(ISBLANK(VLOOKUP(A2,$A$2:$B$4,2,FALSE)),"",VLOOKUP(A2,$A$2:$B$4,2,FALSE))
Try..in C2
=IF(ISBLANK(VLOOKUP(A2,$A$2:$B$4,2,FALSE)),"",VLOOKUP(A2,$A$2:$B$4,2,FALSE))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks