Help with Excel Lists.

worstuser

New Member
Joined
Jul 31, 2007
Messages
3
Hi,

Ok my problem is i trying to find out if possible to use a list which will pull information about the item selected. For example i have the below information in Sheet 1 and in Sheet 2 i have a list whith the car makes in A1. Now when i select the car make i want the color & make to appear also but in different cells on Sheet 2.

Example:


A / B / C

make / color / model

bmw / silver / S300
vw / red / rabbit
mercedes / black / S400
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Welcome to the board.

Look at the VLOOKUP Function..

On Sheet2, put in B1

=VLOOKUP(A1,Sheet1!A:C,2,False)

That will bring back the color

And in C1

=VLOOKUP(A1,Sheet1!A:C,3,False)
will bring back the model
 

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Oooops!! My bad. Check previous post again. I've corrected a typo.
 

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,210
Sheet1
Book4
ABCD
1makecolormodel
2bmwsilverS300
3vwredrabbit
4mercedesblackS400
5
Sheet1


Sheet2
Book4
ABCDE
1bmwsilverS3001
2
3
Sheet2


B1, copied to C1:

=INDEX(Sheet1!B2:B4,$D1)

D1:

=MATCH(A1,Sheet1!$A$2:$A$4,0)
 

Forum statistics

Threads
1,181,659
Messages
5,931,273
Members
436,786
Latest member
Deniel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top