Jul 21 2021 01:20 AM
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 vertical lookup for "jan" i want a return of "groen".
Who can help me?
a | b | c | d | |
1 | jan | huis | rood | appel |
2 | bert | boot | blauw | banaan |
3 | hans | auto | groen | peer |
4 | erik | motor | geel | meloen |
5 | bassie | caravan | paars | druif |
Jul 21 2021 03:46 AM
Solution
=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); "")
Jul 21 2021 04:15 AM
@Hans Vogelaar Thanks you very much!
Jul 21 2021 03:46 AM
Solution
=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); "")