Vlookup Help

[patterson1988]

Hi i need some help please,

i am building a data speadsheet, with a front cover to take out information from the main datasheet

For example i want to type a Airline destination (LAX) & next to it in a blocked of cells, show which airlines fly there and the details about them (More then one airline per destination).

So far i can get it to show some data i want, but the bit i am struggling with is to show all lines with LAX agaist them rather then just duplicaing the same line, i can do it by physically telling it wich line, but the data will keep growing, so is there a simple code to use, so i can keep adding data and destinations?




i have attached the file, (yes very basic at the moment) so please help me

[patterson1988]

Sorry & thankyou, i have amended the title, not to sure what else to name it :s

[Richard Buttrey]

Hi,

You need to use the Advanced Data Filter functionality, not a VLOOKUP() function.

[patterson1988]

Hi,

You need to use the Advanced Data Filter functionality, not a VLOOKUP() function.

many thanks i will try that

[patterson1988]

Cant work that could you please provide a example? Will only let me copy to current worksheet, i want all the data on one page and to be able to search it on another

[Richard Buttrey]

Hi,

You need to start the Data Filter on the sheet which should receive the results.

I've created a macro in the attached to do it for you but you would be advised to learn how to use this powerful functionality and be able to do it manually first.

[patterson1988]

you sir are a legend, didnt expect you to do it for me, much appricated, yes i do need to learn so i am going to read your macro to see how you did it. Thanks agin