Is is possible to say

=IF(ISNA(VLOOKUP($X996,Weights.xls!w"VALUE IN CELL C5"s,3,FALSE))

?

Yes.

Look in HELP for the INDIRECT() function

Post again in this same thread if you can't get it done

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Stephen" <(E-Mail Removed)> wrote in message news:CCCE7DA8-1610-4A03-8685-(E-Mail Removed)...
| Is is possible to say
|
| =IF(ISNA(VLOOKUP($X996,Weights.xls!w"VALUE IN CELL C5"s,3,FALSE))
|
| ?

Almost. If the Weights.xls book is open, you can use the INDIRECT function:
syntax: INDIRECT(address_string)
with <address_String>: [book_name]sheet_name!range_address_or_name
So something like
ISNA(VLOOKUP($X996
, INDIRECT("[Weights.xls]worksheet_name!w" & C5 & "s")
,3,FALSE) )

--
Regards,
Sébastien
<http://www.ondemandanalysis.com>


"Stephen" wrote:

> Is is possible to say
>
> =IF(ISNA(VLOOKUP($X996,Weights.xls!w"VALUE IN CELL C5"s,3,FALSE))
>
> ?

I see.

So even if I qualify the path to the Weights book, it simply won't work.
Damn.

Oh well.

Thanks.

"sebastienm" wrote:

> Almost. If the Weights.xls book is open, you can use the INDIRECT function:
> syntax: INDIRECT(address_string)
> with <address_String>: [book_name]sheet_name!range_address_or_name
> So something like
> ISNA(VLOOKUP($X996
> , INDIRECT("[Weights.xls]worksheet_name!w" & C5 & "s")
> ,3,FALSE) )
>
> --
> Regards,
> Sébastien
> <http://www.ondemandanalysis.com>
>
>
> "Stephen" wrote:
>
> > Is is possible to say
> >
> > =IF(ISNA(VLOOKUP($X996,Weights.xls!w"VALUE IN CELL C5"s,3,FALSE))
> >
> > ?

<it simply won't work>

What does that mean? Error message? What message?
Wrong result? If so, supply the input values, the result you expected and what you got instead.


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Stephen" <(E-Mail Removed)> wrote in message news:E9E03B39-E5C3-4A59-8F18-(E-Mail Removed)...
|I see.
|
| So even if I qualify the path to the Weights book, it simply won't work.
| Damn.
|
| Oh well.
|
| Thanks.
|
| "sebastienm" wrote:
|
| > Almost. If the Weights.xls book is open, you can use the INDIRECT function:
| > syntax: INDIRECT(address_string)
| > with <address_String>: [book_name]sheet_name!range_address_or_name
| > So something like
| > ISNA(VLOOKUP($X996
| > , INDIRECT("[Weights.xls]worksheet_name!w" & C5 & "s")
| > ,3,FALSE) )
| >
| > --
| > Regards,
| > Sébastien
| > <http://www.ondemandanalysis.com>
| >
| >
| > "Stephen" wrote:
| >
| > > Is is possible to say
| > >
| > > =IF(ISNA(VLOOKUP($X996,Weights.xls!w"VALUE IN CELL C5"s,3,FALSE))
| > >
| > > ?

It returns a #REF error because my weights.xls will not be open all the time.
the kicker for this to work is to have that weights workbook always open
which is not feasible in my situation.



"Niek Otten" wrote:

> <it simply won't work>
>
> What does that mean? Error message? What message?
> Wrong result? If so, supply the input values, the result you expected and what you got instead.
>
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "Stephen" <(E-Mail Removed)> wrote in message news:E9E03B39-E5C3-4A59-8F18-(E-Mail Removed)...
> |I see.
> |
> | So even if I qualify the path to the Weights book, it simply won't work.
> | Damn.
> |
> | Oh well.
> |
> | Thanks.
> |
> | "sebastienm" wrote:
> |
> | > Almost. If the Weights.xls book is open, you can use the INDIRECT function:
> | > syntax: INDIRECT(address_string)
> | > with <address_String>: [book_name]sheet_name!range_address_or_name
> | > So something like
> | > ISNA(VLOOKUP($X996
> | > , INDIRECT("[Weights.xls]worksheet_name!w" & C5 & "s")
> | > ,3,FALSE) )
> | >
> | > --
> | > Regards,
> | > Sébastien
> | > <http://www.ondemandanalysis.com>
> | >
> | >
> | > "Stephen" wrote:
> | >
> | > > Is is possible to say
> | > >
> | > > =IF(ISNA(VLOOKUP($X996,Weights.xls!w"VALUE IN CELL C5"s,3,FALSE))
> | > >
> | > > ?
>
>
>