Re: Re:compare to array in another workbook and record results

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 20:56:37 +0100

Hi
if you receive an #NA# error this would inidcate that there's no match
for D3 in your lookup table. You may have to adapt the sheetname for
the lookup range 

--
Regards
Frank Kabel
Frankfurt, Germany
Carole wrote:
> I tried eliminating the row absolute, it gave me 0's.  The vlookup
> gives me #N/A.
>
>      ----- Charlie wrote: -----
>
>      Carole,
>
>      Try  =IF(D3='file_name.xls'!$C3:$C456,'file_name.xls'!
>      $B3:$B456,0)
>
>      or =VLOOKUP(D3,[file_name.xls]Sheet1!$C$3:$C$456,1,FALSE)
>
>      Charlie O'Neill
>      >-----Original Message-----
>      >I am trying to compare the value of a cell in the
>      destination workbook to an array in a source workbook.  If
>      a match is found, Excel then grabs the value from a
>      cooresponding array in the source workbook and pull it
>      into the cell in the destination workbook.  If there is no
>      match, record 0.
>      >=IF(D3='file_name.xls'!$C$3:$C$456,'file_name.xls'!
>      $B$3:$B$456,0)
>      >>It pulls in the correct figure on the first cell I plug
>      this formula into, but when I copy/autofil the formula to
>      other cells, it puts 0's in all the other cells.  If I
>      take out the absolute reference, it pulls in the correct
>      info for several cells, and puts 0's in the rest.  If I go
>      back to these cells and correct the array numbering to the
>      original 3:456, it puts in 0's.
>      >.
>      >