Help creating log with data from table

Hi Bryan,
Here is something else I have just learnt that maybe of use to you. Forgive me if I am trying to teach you the obvious.

From the previous post if you put the formula in B1 on sheet 2 and drag the formula down this gives you 2 problems.

It will not cell reference so the formula in B1 sheet 2 needs to be
=VLOOKUP(A1,Sheet1!$A$1:$C$3,2)
you can then drag B1 down to auto complete when you fill in A2, A3 etc in sheet 2.

This will return a column of #NA where there is nothing in the corresponding cell in column A.

If you put this formula in B1 and then drag it down it will leave the cell blank if nothing is entered into the cell in column A.

=IF(ISNA(VLOOKUP(A1,Sheet1!$A$1:$C$3,2,FALSE))=TRUE,"",VLOOKUP(A1,Sheet1!$A$1:$C$3,2,FALSE))

Hope this helps.

Greg.