How can I retrieve information into a cell from another document .

[Max G.]

I have two documents, one is the source of data the other target. I need to
retrieve the value of a cell into a target document if three values in the
source doc are met.
Here is some of my logic:
If [source doc]a1=earth,b1=glob,c1=us then copy d1 into the target document
cell b23. I hope this gives you an idea what I am trying to do. Vlookup
searches only the first column and does not offer multiple conditions.

 

[Frank Kabel]

Hi
try the following array formula (entered with CTRL+SHIFT+ENTER):
=INDEX('source'!D1100,MATCH(1,('source'!A1:A100="earth")*('source'!B1
:B100="glob")*('source'!C1:C100="us"),0))

--
Regards
Frank Kabel
Frankfurt, Germany

I have two documents, one is the source of data the other target. I need to
retrieve the value of a cell into a target document if three values in the
source doc are met.
Here is some of my logic:
If [source doc]a1=earth,b1=glob,c1=us then copy d1 into the target document
cell b23. I hope this gives you an idea what I am trying to do. Vlookup
searches only the first column and does not offer multiple

conditions.

 

[Ken Wright]

One way:- Assuming your source book is 'Test Book2.xls' and the path was
F:\4mydata\ then in cell B23 in your target book put the following formula

=IF(AND('F:\4mydata\[Test Book2.xls]Sheet1'!$A$3="Earth",'F:\4mydata\[Test
Book2.xls]Sheet1'!$B$3="Glob",'F:\4mydata\[Test
Book2.xls]Sheet1'!$C$3="US"),'F:\4mydata\[Test Book2.xls]Sheet1'!$D$1,"")

You didn't specify what to appear if they did not meet the criteria so I have
assumed you want a blank.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

I have two documents, one is the source of data the other target. I need to
retrieve the value of a cell into a target document if three values in the
source doc are met.
Here is some of my logic:
If [source doc]a1=earth,b1=glob,c1=us then copy d1 into the target document
cell b23. I hope this gives you an idea what I am trying to do. Vlookup
searches only the first column and does not offer multiple conditions.

 

[Cutter]

Use this formula in cell B23 of your target doc:

=if(and(A1="earth",B1="glob",C1="us"),D1,"")

change the formula accordingly to designate A1,B1,C1 and D1 as bein
your source do