Posted on

Finding missing values

Finding missing values

Look at cell A2 and compare it with sheet Week_4 cells A2-H25,000.  If A2 exists enter the value of column 4 into this cell.  If not enter “Nay There”.

=IFERROR(VLOOKUP($A2,Week_4!$A$2:$H$25000,4,FALSE),"Nay There")