Hi,
I want to do a data validation in cell A1,where selecting any of the cell options the data would change as per source file,I have tried with index match but without success.The sequence of data will be
Selecting KOLwould give me below data -
kol.jpgtable C3-o5
Selecting WB would show me this data
wb.jpgc6-o8
Last edited by arnab0711; 01-24-2012 at 06:46 AM.
Assuming I'm understanding your requirements correctly then in cell B3 of your COL sheet put the formula:
=INDEX(source!$C$3:$O$8,MATCH($A$1,source!$B$3:$B$8,0)+ROW()-3,COLUMN()-1)
And copy across and down.
Ηι
I assume that something like what ι suggested you,yesterday, is not OK, for you?
http://www.excelforum.com/excel-gene...example-2.html
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks its working now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks