Thanks now here is second part of question: Do I need it to match as the
range
will be from C6:C14 (apple,banana, pear etc that it needs to match so does
L35:
=IF(G35=$C$6:$C$14,$AA$2,"") work then? i have numerous areas i would like
to do this in.

"JE McGimpsey" wrote:

> Note that worksheet functions in cells can't "put" values in other
> cells. If you want a worksheet solution, then one way:
>
> L35: =IF(G35=$C$6,$AA$2,"")
>
> Copy L35 to L35:M126
>
> In article <9EE04C79-672D-4C9A-B091-(E-Mail Removed)>,
> Khanjohn <(E-Mail Removed)> wrote:
>
> > Here goes. say I have a topic in C6 named banana (drop down menu) and I
> > want it to look up data( will have from apple to zulu fruit) in G35 :H126 and
> > if it matchs then put the value of aa2 which is 2 in the appropiate column
> > in L35:M126. What is the frormula in excel not VBA? IE C6 is apple going down
> > G column it finds apple at 37, 39, 56, 78,79, 80, 100, 126 and in the H
> > column it finds apple in 38, 52, 56, 126. I wnt it to put a 2 in each of the
> > correct cells down the L and M columns.
> >
> > Thanks in advance

You really need to explain your layout better. Do you have a table of values in G35 :H126 that
associate values with words?

If that is the case, perhaps:

=VLOOKUP(C6, $G$35:$H$126, 2, False)

Which can be copied down.

HTH,
Bernie
MS Excel MVP


"Khanjohn" <(E-Mail Removed)> wrote in message
news:514DF135-2F68-43D3-876C-(E-Mail Removed)...
> Thanks now here is second part of question: Do I need it to match as the
> range
> will be from C6:C14 (apple,banana, pear etc that it needs to match so does
> L35:
> =IF(G35=$C$6:$C$14,$AA$2,"") work then? i have numerous areas i would like
> to do this in.
>
> "JE McGimpsey" wrote:
>
>> Note that worksheet functions in cells can't "put" values in other
>> cells. If you want a worksheet solution, then one way:
>>
>> L35: =IF(G35=$C$6,$AA$2,"")
>>
>> Copy L35 to L35:M126
>>
>> In article <9EE04C79-672D-4C9A-B091-(E-Mail Removed)>,
>> Khanjohn <(E-Mail Removed)> wrote:
>>
>> > Here goes. say I have a topic in C6 named banana (drop down menu) and I
>> > want it to look up data( will have from apple to zulu fruit) in G35 :H126 and
>> > if it matchs then put the value of aa2 which is 2 in the appropiate column
>> > in L35:M126. What is the frormula in excel not VBA? IE C6 is apple going down
>> > G column it finds apple at 37, 39, 56, 78,79, 80, 100, 126 and in the H
>> > column it finds apple in 38, 52, 56, 126. I wnt it to put a 2 in each of the
>> > correct cells down the L and M columns.
>> >
>> > Thanks in advance
>

Ok

C6 Banana
(AA 2) Banana (AB 2) 3
C7 Orange
(AA 3) Apple (AB 3) 2
C8 apple
(AA 4) Onion (AB 4) 1
C9 Onion
(AA 5) Orange (AB 5) 0





data here doesnt matter C35 Banana D35 Orange E 35 ( answer for
C35) F 35 Answer for D35. continues down list.

"Bernie Deitrick" wrote:

> You really need to explain your layout better. Do you have a table of values in G35 :H126 that
> associate values with words?
>
> If that is the case, perhaps:
>
> =VLOOKUP(C6, $G$35:$H$126, 2, False)
>
> Which can be copied down.
>
> HTH,
> Bernie
> MS Excel MVP
>
>
> "Khanjohn" <(E-Mail Removed)> wrote in message
> news:514DF135-2F68-43D3-876C-(E-Mail Removed)...
> > Thanks now here is second part of question: Do I need it to match as the
> > range
> > will be from C6:C14 (apple,banana, pear etc that it needs to match so does
> > L35:
> > =IF(G35=$C$6:$C$14,$AA$2,"") work then? i have numerous areas i would like
> > to do this in.
> >
> > "JE McGimpsey" wrote:
> >
> >> Note that worksheet functions in cells can't "put" values in other
> >> cells. If you want a worksheet solution, then one way:
> >>
> >> L35: =IF(G35=$C$6,$AA$2,"")
> >>
> >> Copy L35 to L35:M126
> >>
> >> In article <9EE04C79-672D-4C9A-B091-(E-Mail Removed)>,
> >> Khanjohn <(E-Mail Removed)> wrote:
> >>
> >> > Here goes. say I have a topic in C6 named banana (drop down menu) and I
> >> > want it to look up data( will have from apple to zulu fruit) in G35 :H126 and
> >> > if it matchs then put the value of aa2 which is 2 in the appropiate column
> >> > in L35:M126. What is the frormula in excel not VBA? IE C6 is apple going down
> >> > G column it finds apple at 37, 39, 56, 78,79, 80, 100, 126 and in the H
> >> > column it finds apple in 38, 52, 56, 126. I wnt it to put a 2 in each of the
> >> > correct cells down the L and M columns.
> >> >
> >> > Thanks in advance
> >
>
>
>

In E35:

=VLOOKUP(C35,$AA$2:$AB$5,2,FALSE)

Copy to F35, then copy E35:F35 down to match your list....

HTH,
Bernie
MS Excel MVP


"Khanjohn" <(E-Mail Removed)> wrote in message
news:A178D866-61DD-4097-AE71-(E-Mail Removed)...
> Ok
>
> C6 Banana
> (AA 2) Banana (AB 2) 3
> C7 Orange
> (AA 3) Apple (AB 3) 2
> C8 apple
> (AA 4) Onion (AB 4) 1
> C9 Onion
> (AA 5) Orange (AB 5) 0
>
>
>
>
>
> data here doesnt matter C35 Banana D35 Orange E 35 ( answer for
> C35) F 35 Answer for D35. continues down list.
>
> "Bernie Deitrick" wrote:
>
>> You really need to explain your layout better. Do you have a table of values in G35 :H126 that
>> associate values with words?
>>
>> If that is the case, perhaps:
>>
>> =VLOOKUP(C6, $G$35:$H$126, 2, False)
>>
>> Which can be copied down.
>>
>> HTH,
>> Bernie
>> MS Excel MVP
>>
>>
>> "Khanjohn" <(E-Mail Removed)> wrote in message
>> news:514DF135-2F68-43D3-876C-(E-Mail Removed)...
>> > Thanks now here is second part of question: Do I need it to match as the
>> > range
>> > will be from C6:C14 (apple,banana, pear etc that it needs to match so does
>> > L35:
>> > =IF(G35=$C$6:$C$14,$AA$2,"") work then? i have numerous areas i would like
>> > to do this in.
>> >
>> > "JE McGimpsey" wrote:
>> >
>> >> Note that worksheet functions in cells can't "put" values in other
>> >> cells. If you want a worksheet solution, then one way:
>> >>
>> >> L35: =IF(G35=$C$6,$AA$2,"")
>> >>
>> >> Copy L35 to L35:M126
>> >>
>> >> In article <9EE04C79-672D-4C9A-B091-(E-Mail Removed)>,
>> >> Khanjohn <(E-Mail Removed)> wrote:
>> >>
>> >> > Here goes. say I have a topic in C6 named banana (drop down menu) and I
>> >> > want it to look up data( will have from apple to zulu fruit) in G35 :H126 and
>> >> > if it matchs then put the value of aa2 which is 2 in the appropiate column
>> >> > in L35:M126. What is the frormula in excel not VBA? IE C6 is apple going down
>> >> > G column it finds apple at 37, 39, 56, 78,79, 80, 100, 126 and in the H
>> >> > column it finds apple in 38, 52, 56, 126. I wnt it to put a 2 in each of the
>> >> > correct cells down the L and M columns.
>> >> >
>> >> > Thanks in advance
>> >
>>
>>
>>