let say in sheet you have

in 1st ,2nd ,3rd row you have:
set1 1 1 1 ' in A B C D CELLS
set2 2 2 2 ' in A B C D CELLS
set3 3 3 3 ' in A B C D CELLS

in sheet2 let say
cell a1 is combo box where you select the set1 or set 2 or set3

in b1 enter =VLOOKUP(A1,Sheet1!$A$1:$E$3,COLUMN(B1),0)
in C1 enter =VLOOKUP(A1,Sheet1!$A$1:$E$3,COLUMN(c1),0)
in D1 enter =VLOOKUP(A1,Sheet1!$A$1:$E$3,COLUMN(d1),0)
IN E1 enter =VLOOKUP(A1,Sheet1!$A$1:$E$3,COLUMN(e1),0)


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=382257