I'm just wondering what would be an easy formula to use if I am trying to compare B1 to A1:A10 and then if there is a cell matching in the A column then I want B1 to show that value but if there isn't one then I want it to be left blank.
I'm just wondering what would be an easy formula to use if I am trying to compare B1 to A1:A10 and then if there is a cell matching in the A column then I want B1 to show that value but if there isn't one then I want it to be left blank.
Last edited by knitterkuba; 12-26-2010 at 03:14 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks