Using Excel to lookup a list of specifications under the model, not just 1 cell?

Question

Is there a way to use a function like V Lookup or H Lookup to report an entire list of specifications.

I will have specifications for different models down the list and I want a way where if I select a model from a list (or type the model number into a cell) then it will report below a list of the specifications for that model - it will need to show the first list (the headings) and also the model specific detail (i.e. Indoor Size 900mm *next line* Outdoor Size 1000mm etc)

If it's too hard then I can list the headings permanently on the sheet and just have the results only being reported.

Answer 1

Data Validation and VLOOKUP should be able to handle the job, assuming you have the spec list in a tidy table:

Spec Sheet, Column A: Models

Column B: Indoor Size

Column C: Outdoor Size



If you have Excel 2007 or 2010, you can turn the above list into a Table that allows you to sort the list and improve references to particular columns. The Tables tab in the Ribbon allows you to give the table a unique name (such as Table1). You can then refer to the items in the Models column using a Named Range (Ctrl+F3):

ModelsList = Table1[Models]



On your search sheet, the headings should be entered manually (though you could also use simple formulas):

'Search Sheet'!A1 = "Models" -OR- ='Spec Sheet'!A1

B1 = "Indoor Size"



Use Data Validation to limit the entries to the data entered in the table.

Search Sheet, A2 Data Validation

Allow: List

Source: =ModelsList



Next to these, use VLOOKUP to pull values based on your search cell (A2 in this example):

B2 =VLOOKUP(A2, Table1, 2)

C2 =VLOOKUP(A2, Table1, 3)

Answer 2

1

Answer 3

A reverse cell phone lookup service I have used is http://reversephone.toptips.org



Enter the number in the system and they will tell you a lot of informations about the phone number and the person who owns it.

If they have extra details you will have to pay for the report.

Free reverse phone lookup sites generally don't provide anything interesting. To get further information, money will have to be paid. The free searches do not provide much more than what can be found through the phone book.

The best thing is that you can get informations about anyone!!

Answer 4

There are a couple of ways to do this. If both lists have the same amount of numbers, then the easiest way to compare the numbers is to sort both lists and compare the values by eye or through one of the logic formulas =IF(). If this is not working you may want to try to use Access instead. With Access you can create two data bases, one for each list, link the databases and run a query pulling up each of the values that coincide. If Access is not an option, then you may want to try a macro. The macro would choose each value on one list then search the corresponding list for the equivalent value. Once the macro found a match it would copy the matches to a seperate pair of columns.

Answer 5

Hello David,



You can create a Macro in MS Excel VBA to do the process.



You can contact me in www.oDesk.com my username is Evan Badelles. Just search. Thanks.

Answer 6

Try autofilter.