I have a row of dates in row 100 and a row of values in row 101.
If I enter a date (which matches one of dates in row 100) into cell F10 then I want the corresponding value to appear in cell F11.
What formula should I enter into cell F11?
1 Like
@schiavinatto Since the question specify only rows, but did not columns, then maybe it is worth excluding the columns from the formula? I mean something like
=IFERROR(HLOOKUP(F10;100:101;2;0);"Nonexistent.")
It is not advisable to leave the search area free, if there is a large amount of this formula, the execution time will be extended.
1 Like
Hello @schiavinatto. Many thanks for your really useful and well illustrated response to my question. Problem solved.