Vlookup

[Mary]

I have 3 workbook and need to extract data from WkBk 2 & 3
into Workbook 1. I am using the VLookup and was able to
extract the data from workbook into workbook 1 using this
command =VLOOKUP (A4,'D:\SE
Excel\[po.xls]Sheet1'!$A$1:$F$1000,6,0). However,
whenever, I make changes to get the data from the 3rd
workbook, I get #ref!. The 3rd workbook name is purch.xls
and the Lookup column is G2 and the lookup range is
$C$1:$c$1000,7,0). The data I am looking to extract is a
date. So, in others words When the purchase order in
Workbook one matches in workbook 3 then I need to extract date.

Thanks in Advance for Anybody help and as usually needed
this info yesterday.

Mary

 

[Frank Kabel]

Hi Mary
what kind of changes do you male in the 3rd workbook (deleting rows
eventually?). If you just have to adapt the VLOOKUP formula try
=VLOOKUP (G2,'D:\SEExcel\[purch.xls]Sheet1'!$C$1:$G$1000,5,0).

 

[Mary]

That didn't work and I had tried it before, but tried it
again.

In Workbook one in Column G2..G20 I have Purchase orders
numbers that were extracted from Workbook 2, (po.xls),
correctly.

Now I am trying to match that purchase order number in
workbook 3, (purch.xls), that data needs to be placed in
column K2..K20 in Workbook 1 (s0.xls).

In workbook 1, (so.xls columns a-e data was already
there. columns f-j is extracted from workbook 2
(po.xls). And now I need to extract data from workbook 3
(purch.xls) into column K2..k20. Since I am using test
data I copied the purchase order numbers from wkbk3 into
WkBk 1 then I will use real data.

-----Original Message-----
Hi Mary
what kind of changes do you male in the 3rd workbook (deleting rows
eventually?). If you just have to adapt the VLOOKUP formula try
=VLOOKUP (G2,'D:\SEExcel\[purch.xls]Sheet1'! $C$1:$G$1000,5,0).

--
Regards
Frank Kabel
Frankfurt, Germany

I have 3 workbook and need to extract data from WkBk 2 & 3
into Workbook 1. I am using the VLookup and was able to
extract the data from workbook into workbook 1 using this
command =VLOOKUP (A4,'D:\SE
Excel\[po.xls]Sheet1'!$A$1:$F$1000,6,0). However,
whenever, I make changes to get the data from the 3rd
workbook, I get #ref!. The 3rd workbook name is purch.xls
and the Lookup column is G2 and the lookup range is
$C$1:$c$1000,7,0). The data I am looking to extract is a
date. So, in others words When the purchase order in
Workbook one matches in workbook 3 then I need to extract date.

Thanks in Advance for Anybody help and as usually needed
this info yesterday.

Mary

.

 

[Frank Kabel]

Hi Mary
should work. If you like email me your spreadsheets and I'll insert a
working formula (frank[dot]kabel[at]freenet[dot]de)


--
Regards
Frank Kabel
Frankfurt, Germany

That didn't work and I had tried it before, but tried it
again.

In Workbook one in Column G2..G20 I have Purchase orders
numbers that were extracted from Workbook 2, (po.xls),
correctly.

Now I am trying to match that purchase order number in
workbook 3, (purch.xls), that data needs to be placed in
column K2..K20 in Workbook 1 (s0.xls).

In workbook 1, (so.xls columns a-e data was already
there. columns f-j is extracted from workbook 2
(po.xls). And now I need to extract data from workbook 3
(purch.xls) into column K2..k20. Since I am using test
data I copied the purchase order numbers from wkbk3 into
WkBk 1 then I will use real data.

-----Original Message-----
Hi Mary
what kind of changes do you male in the 3rd workbook (deleting rows
eventually?). If you just have to adapt the VLOOKUP formula try
=VLOOKUP (G2,'D:\SEExcel\[purch.xls]Sheet1'! $C$1:$G$1000,5,0).

--
Regards
Frank Kabel
Frankfurt, Germany

I have 3 workbook and need to extract data from WkBk 2 & 3
into Workbook 1. I am using the VLookup and was able to
extract the data from workbook into workbook 1 using this
command =VLOOKUP (A4,'D:\SE
Excel\[po.xls]Sheet1'!$A$1:$F$1000,6,0). However,
whenever, I make changes to get the data from the 3rd
workbook, I get #ref!. The 3rd workbook name is purch.xls
and the Lookup column is G2 and the lookup range is
$C$1:$c$1000,7,0). The data I am looking to extract is a
date. So, in others words When the purchase order in
Workbook one matches in workbook 3 then I need to extract date.

Thanks in Advance for Anybody help and as usually needed
this info yesterday.

Mary

.