mardi 27 novembre 2018

IF(ISERROR(VLOOKUP...)) In EXCEL

[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