Hi!
That's fine if B1 is blank. If B1 isn't blank and isn't
found in the lookup table, you'll still get #N/A. Of
course, if the lookup value will always be found in the
lookup table then that's not a problem.
If you use the IF ISNA formula, you cover both
possibilities.
Biff
-----Original Message-----
I would have used an =IF( statement first, before going
into my =VLOOKUP(
=if(b1="",0,vlookup(b1,criteria name,column ref))
I hope I explained this to you correctly, as I used this
format regularly
and it works.
"Cmatise" wrote:
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,False))
HTH
Michael
"Cmatise" wrote:
When VLOOKUP returns a #N/A How can you get it to
replace #N/A with a 0
.
|