Hi fellas, i need to convert this formula
=IFERROR(VLOOKUP(I5;Sheet4!F:G;2;FALSE);0)
into an INDEX MATCH one... (since i need to copy pivot data in Sheet4)
i tried looking at tutorials, but I can't fix it... i tried many combos...
If someone could help that'd be great.
thank you in advance,
ButterLord
p.s.
i did not paste copies since it's sensible data.
basically: i need to copy the second column's value of a section of Sheet4 into the working one thanx to a matching number present in both.
Bookmarks