Hello,
I have a niggling problem with a worksheet when using Hlookup to return a value from a range of cells it is coming up with blanks when there is data in the range.
There is only ever one row cell containing text in the specified range and i need this to be returned in another column.
The problem with the hlookup formula i am using is that it will not work if cells contain formulas and in the range i am working on all cells contain formulas.
I know this formula works if there is text without a formula in the cell range, as soon as it hits a cell with a formula though it won't work.
I have attached the sheet and would be grateful if anyone could offer a solution to this
from j1:p38 there is one cell with text i wish to be returned in column q for each row. eg in q1 the first cell text returned would be [TABLE="width: 113"]
[tr]
[TD="class: xl63, width: 113"]khawatim. q2 should contain cantor etc etc.[/TD]
[/TABLE]
many thanks
paul