autofilling data based on criteria

[jul4ka]

Hello,

i have been searching for a wile but could not find an answer that suits me.

I have data set and would like to make auto fill.

I have created drop-down list (data validation) which will be criteria. The data will be on a other sheet hidden.
i would like that data would fill automatically when criteria from drop down list is selected.


I was thinking maybe you could help me with VBA code or maybe exists method that does without macro?



Thank you.

[alansidman]

Look at the Vlookup function

http://www.techonthenet.com/excel/formulas/vlookup.php

Alan