Try:
=IFERROR(IF(ISNUMBER(O2),VLOOKUP(A2,Sheet2!$C$2:$E$10,3,FALSE),""),"")
=IFERROR(IF(ISNUMBER(O2),INDEX(Sheet2!$E$2:$E$10,MATCH(A2,Sheet2!$C$2:$C$10,0)),""),"")
where the first "" means that O2 is not a number, ...READ MORE
Nov 17, 2022
in Others
by
narikkadan
• 63,600 points
•
789 views