Originally Posted by
TMShucks
You're welcome. Thanks for the rep.
MATCH($C$6,Kaynak!$C:$C,0) finds the relevant row in the Kaynak sheet using the result from the data validation drop down box.
ROW($E1)-1 and COLUMN(E$1) just provide suitable offsets so that the formula can be dragged across and down ... rather than hard coding 1, 2, 3, ... etc
Try putting "=ROW(E1)" in a cell ... it will return 1; "=COLUMN(E1)" will return 5.
I usually have to experiment a little to get the right reference ... but I'm getting better ;-)
Regards
Bookmarks