Need help to sort out the formula

[Ahmed Fawad]

Hi here is the table

LocationCode	CustomerName	Party_Type	City
501	Tamweel (P.J.S.C)	ORGANIZATION	Dubai
502	Tamweel (P.J.S.C)	ORGANIZATION	Dubai
503	Tamweel (P.J.S.C)	ORGANIZATION	Dubai
504	IL KANG	PERSON	dubai
505	Ahmed Farukh Sameen Alam	PERSON	Dubai
506	Akshaya Kumar Parija	PERSON	Dubai
507	Saleem Mirza	PERSON	UAQ
508	Tamweel (P.J.S.C)	ORGANIZATION	Dubai
509	Manab Kumar Kundu	PERSON	Dubai
510	ASHOK RUPANI KOMAL	PERSON	DUBAI
511	Mark Kremers	PERSON
512	Lana B. S. Nahawi	PERSON	Dubai
513	Moussa Abdourahman Ahmed	PERSON	DUBAI
514	Victor Ramanan	PERSON	DUBAI
515	RACHID AL ASSAF	PERSON	dubai
516	Zareen Akhtar Butt	PERSON	Bur Dubai: Dubai

<tbody>
</tbody>

thats the data and here I'm doing input to get the details:

Cluster	Property	Name	Type	City	REMARKS
5	12
5	9
5	4

<tbody>
</tbody>

Now from data from data LOCATION CODE is combination of cluster and property.

i.e. cluster 5 property 12 is the 512 location code.
Now i need the name of the customer from locationcode 512.


Any help ?

 

[steve the fish]

Vlookup function can use a concatenation.

=VLOOKUP(Cluster&Property,Table,2,0)

 

[Andrew Poulsom]

Continued here:

http://www.mrexcel.com/forum/excel-questions/804757-need-work-formulas-get-data.html