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")