Still stuck on locating names in a list and attaching relevant data

[nickymac]

I had put up a post earlier, then thought I had cracked it with the advice from the forum with a vlookup but didn't work
The vlookup wasn't bringing through the right data. Is this because I want it to locate the name in a seperate list, then attach two rows onto the first list from the 2nd? Don't think the match/index will do it either.

Have created a new example as this directly relates to what I am doing. This is exactly what I need to do, obviously the data is just made up to show the mechanism of my spreadsheet. In column R and S I have highlighted the attempt of my vlookup, which doesn't work. As you can see there are different people in data 2, this data set is longer meaning i cant just sort and then do a simple if formula or something similar.

I need to link each name to their directorate and section dept/name so I can charge these departments the cost for their computers. This needs done asap so anyone who could help please do because the data is over 3500 people long on either side!

[EdMac]

e.g

Please Login or Register  to view this content.

change this to

=VLOOKUP(L7,A$7:C$20,2,false)

[nickymac]

great, thanks! what does the false do?

[EdMac]

If you use the false criteria, the list does not have to be sorted - from excel help