thank you so so much!!!!!!!!!!!!!!!!!!! i almost spent 2 hours on google to find the solutionyou can use this
Code:=IFERROR(VLOOKUP(A2,siteline,2,0),"")
Hello Experts,
I want to bring the value from sheet two both vendor name and vendor number to sheet 1, but Voolup is not working.
I would highly appreciate if someone can help me with this error and report.
Regards,
Nitika Manhas
=INDEX(Sheet2!$A$2:$A$602,MATCH([@[MANDATORY
]],Sheet2!$B$2:$B$602,0))