Vlookup

  • Thread starter Thread starter Mary
  • Start date Start date
M

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
 
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).
 
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
Click to expand...

.
Click to expand...
 
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
Click to expand...

.
Click to expand...
Click to expand...
 
Back
Top