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.
If the one vaue does contain text and not a number either
=HLOOKUP("*",B4:U4,1,FALSE) if the cells are blank
or if they are ?
entered as an array (holding down shift control then hiting enter to enter the formula)
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1