[enter image description here][1]
I am using the following code. I am using the function IF(ISERROR(VLOOKUP...)) in order to check across all the sheets in order to return back the value otherwise "Missing Value".
IF(ISERROR(VLOOKUP(RDR!B2,$J$3:$J$11798,1,FALSE),"Missing Value"),IF(ISERROR(VLOOKUP(ETF!B2,Sheet7!$J$3:$J$11798,1,False),"Missing Value"))
Aucun commentaire:
Enregistrer un commentaire