Did you try

=IF(ISNA(VLOOKUP('Weekly Draw'!B1,'Install Panels'!$A$4:$F$43
,6,FALSE)),"",VLOOKUP('Weekly Draw'!B1,'Install Panels'!$A$4:$F$43
,6,FALSE))


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Cmatise" wrote in message
...
I Still Cant get it to work.
Let Me show you what I want to Do.

I want to look for the date thats on sheet (weekly Draw B1)
on sheet (Install Panels A4:A43 and when I find a date that matches return
the $ amount that is in the same row in the 3rd column F3:F43

Sheet (Weekly Draw)
A B
1 Date of Draw 12/23/2005
2 Materials Draw
3 Rec. Metal
4 Total Draw


Total Weekly Payroll
A B F
3 Date Qty Installed Draw
4 1/5/05 5.93 $354.22
5 $-
6 $-
7 $-
8 $-
9 $-

"Michael" wrote:

Hi Try

=IF(ISNA(VLOOKUP(Cell,Range,column,FALSE)),"0",VLO OKUP(Cell,Range,Column,Fal
se))

HTH
Michael

"Cmatise" wrote:

When VLOOKUP returns a #N/A How can you get it to replace #N/A with a
0