VLOOKUP function

I am trying to create a function, where there is a drop down menu and the informations are coming from a table on a different worksheet. When I select the item, I want the heading of the item to show up on the next field.
Table
Standard Extra Completed
101 102 103 104 105 106 107 108 109

When I select 101 from the drop down menu standard should showup, or if I select 108 then Completed should showup.

Thnx
Prakash....

Hi Prakash,

Assuming that your drop down menu is in cell A1 of Sheet 1, and assuming
that your table is in Sheet 2, try:

=INDEX(Sheet2!$A$1:$C$1,MATCH("*"&Sheet1!A1&"*",Sh eet2!$A$2:$C$2,0))

Hope this helps!

In article ,
"Prakash" wrote:

I am trying to create a function, where there is a drop down menu and the
informations are coming from a table on a different worksheet. When I select
the item, I want the heading of the item to show up on the next field.
Table
Standard Extra Completed
101 102 103 104 105 106 107 108 109

When I select 101 from the drop down menu standard should showup, or if I
select 108 then Completed should showup.

Thnx
Prakash....