Forum Discussion
Solved
search vertical and horizontal at the same time
Hi, I want to search for a value in Colom A. For example the found value is in cell A2, I want the value of the cel 2kolom right and 2 rows down (cell C4) See table below, so when i will do a...
=IFERROR(INDEX(C1:C5, MATCH("jan", A1:A5, 0)+2), "")
If you use comma as decimal separator, use ; instead of , in the formula:
=IFERROR(INDEX(C1:C5; MATCH("jan"; A1:A5; 0)+2); "")
=IFERROR(INDEX(C1:C5, MATCH("jan", A1:A5, 0)+2), "")
If you use comma as decimal separator, use ; instead of , in the formula:
=IFERROR(INDEX(C1:C5; MATCH("jan"; A1:A5; 0)+2); "")
HansVogelaar Thanks you very much!