Thread
:
Vlookup only taking first line of data
View Single Post
#
6
Posted to microsoft.public.excel.misc
Ardus Petus
Posts: n/a
Vlookup only taking first line of data
In order to be able to use DataFilter, you need to have column headers
above your data
Sheet1:
-----------
A1 = "part_no"
A2 = 12345
Sheet2:
-----------
A1 = "part_no"
A2 thru A999: your part numbers
B1 = "PO_no"
B2 thru B999: your PO no's
etc...
HTH
--
AP
"mickyd67" a écrit
dans le message de news:
...
Ardus - thanks for your help, however that isn't working. Either I am
doing something wrong or I've not explained it correctly.
What I am attempting is:
Sheet 1
Cell A1 = part number 12345
Sheet 2
Column A = various part numbers (several hundred)
Column B = PO number
Column C = PO quantity
Column D = PO due date
Column E = PO required date
Column F = PO actions
Column G = Supplier name
What I want to do is take the PO’s on sheet 2 that belong to part
number 12345 and bring them into sheet 1 in a table that looks at the
part number and pulls all the data that appears in columns B to G for
that part.
Some parts will have one PO – others could have dozens.
Does your idea still work? Or is there another solution?
(also just a note - I am doing this on a spreadsheet with 100+ tabs, 1
per part number and several hundred PO's. Therefore you can see why I
am attempting this)
Cheers.
--
mickyd67
------------------------------------------------------------------------
mickyd67's Profile:
http://www.excelforum.com/member.php...o&userid=35704
View this thread:
http://www.excelforum.com/showthread...hreadid=554890
Reply With Quote