Thank you so much! One more question to complete this. I have this formula in F4 =VLOOKUP($G4,Data!B5:D1476,2) and this formula in H4 =VLOOKUP($G4,Data!B5:D1476,3) returning the correct values for the data I enter in G4. How do I modify these formulas to return a blank cell instead of #N/A in cloumns F and H when there is no value entered in colum G? Thank you!