Thanks Dave and Peo,

This is just what I was looking for " =INDEX(A1:A30,MATCH("sic
code",A1:A30,0)+1)"

Jim Mac Millan :-)


"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:43EA5793.53A99DFB@verizonXSPAM.net...
> One way:
> =INDEX(A1:A30,MATCH("sic code",A1:A30,0)+1)
>
> or if "sic code" is in the cell with other stuff:
> =INDEX(A1:A30,MATCH("*sic code*",A1:A30,0)+1)
>
>
> Jim Mac Millan wrote:
>>
>> Hi,
>>
>> I have been experimenting with the different functions. Vlookup,
>> Search,
>> Find etc. etc. I am not understanding them or I am using them
>> incorrectly.
>>
>> I have a range A1:A30. In that range I want to find out what cell the
>> verbiage "SIC Code" is in. The only thing that seems to come close to
>> what I
>> want to use the is the MATCH function but even that only gives me the
>> row
>> #.
>>
>> I actually want to find the verbiage in the cell below "SIC Code".
>> Since
>> "SIC Code is a moving target I thought that to be the best reference.
>> There
>> are other references I will be tracking as well but if figure this out
>> that'll be half the battle.
>>
>> Thanks For The Help
>> Jim Mac Millan
>
> --
>
> Dave Peterson