Data validation by list

[kennylal]

Hello,

I have two sheets in sheet2 i have data in range (A2:C6) and a common field NAME.

I want to display data from sheet2 to sheet1 using data validation (list type) where in on sheet1 cell A2 contains the list and if i select any name from the list drop down then the respective data from sheet2 should reflect under the same fields on sheet1

Please help
Thanks

 

[TheCman81]

This should easily be achieved by a lookup on Sheet2. Are you able to post some of your data and what you expect the results to be?

 

[kennylal]

Thanks for replying.

For Example:

on Sheet2

Name A/c Branch City
Kenny 00001 XYZ XYZ
Thomas 00002 ABC ABC

On sheet1
on cell (A2) if i have name from sheet two listed via data validation (list type) or others

Name A/c Branch City
then i want cell A4, B4, C4 D4

to be updated (data should fetch (from sheet2) according to names on cell (A2) in sheet1 and display on sheet1 itself the cell reference above.

Thanks

 

[T. Valko]

Hello,

I have two sheets in sheet2 i have data in range (A2:C6) and a common field NAME.

I want to display data from sheet2 to sheet1 using data validation (list type) where in on sheet1 cell A2 contains the list and if i select any name from the list drop down then the respective data from sheet2 should reflect under the same fields on sheet1

Please help
Thanks

See this...

http://contextures.com/xlFunctions02.html

 

[TheCman81]

Copy formula from A4:D4

Assuming you also have headers on Sheet1 A3:D3 that match Sheet2 Headers

=INDEX(Sheet2!$A$2:$D$3,MATCH(Sheet1!$A$2,Sheet2!$A$2:$A$3,0),MATCH(Sheet1!A$3,Sheet2!$A$1:$D$1,0))

You'll obviously need to change the range references above to include your total range

 

[kennylal]

Thank you all for your quick help. I got the result via lookup & data validation.

 

[T. Valko]

Thank you all for your quick help. I got the result via lookup & data validation.

Good deal. Thanks for the feedback!