OOPS - I messed up the closing parenthesis above: should be

=IF(ISNA(VLOOKUP(...)),"",VLOOKUP(...))

apologies.

"reneelimon" wrote:

I hope someone can help me.

I have a workbook with 3 sheets. sheet1=Data Entry, sheet2=daily hours,
sheet3=8day totals.

In sheet1- col a is name, col b is date, col c combines a&b, col d totals
e&f, col e & f are #'s. each row is a different record. These are not
entered in any sort of order.

In Sheet2, col a =dates, row1 col b, c, d, etc are names. For example: i
want cell b2 to get the data from sheet1. i need it to look up the values
from sheet 2-b1 (from sheet1 col a)and sheet2-b2 (rom sheet1 col b), if it
finds a match then enter the resulting number from sheet1-col d, if no match
enter 0.

i have a vlookup function in there now, but if it does not find a match it
results in error #n/a, and i need it to enter 0 if no match found.

I hope this isnt too confusing.

Thank you for your help