Vlookup

[Mary]

I have 2 workbook. The data is as follows:

PO.xls

P.O. # P.O. date S.O. # S.O. Date
15008 10/3/04 9470 10/04/05
15009 10/2/04 9470 10/01/05
15010 10/05/04 8550 10/05/04
SO.xls

S.o. # S.O. date P.O. # P.O. #
9470 10/3/04 15009 15008
9580 10/4/04 15602

vlookup is working unless the S.O. # is listed twice in
Po.xls. Po.xls has the vlookup formula. However, if the
P.O. has the same S.O. number it will only pick up the
first instance. I am using the following formula:

=VLOOKUP(G2,'[sales order.xls]Sheet1'!$A$2:$E$996,2,0).
TheLookup up value is The s.o.#, which is in both workbook.

Please help - need to finish today. This answer will
complete my project.

Mary

 

[Mary]

I use the s.o. number to get date and other data to the
right of the s.o. #. My formula is working, just not when
I have 2 s.o. # in the Po.xls. But it does return the info
for the 1st instance, just not the second. If I list the
s.o. number twice in the so.xls, then it will work. But
normally I will only have the s.o.# listed once in the
so.xls workbook, but could be twice in the po.xls workbook.

Otherwise, everything is working fine.

Mary