i want to do a horizontal lookup across 20 odd cells and pick up the value in the cell containing text. the remaining 19 cells contain question marks but can also be left blank if that makes things easier. The objective is to pick up the one value that contains text.
Bookmarks