Help on if a value from i2:i99 equal a value from b3:b99 then c must equal john

[OXNARD208]

For example
if any value from h3 to h99 equal B4 or any value from b3 to b99 then f must say done.

Thank you,

 

[mikerickson]

Re: If H1:h99 Equal b3 then f must say done.

=IF(SUMPRODUCT(COUNTIF(H3:H99, B3:B99))>0, "done", "somehting else")

 

[OXNARD208]

Re: If H1:h99 Equal b3 then f must say done.

When doing that everything above f11 equal done.

 

[mikerickson]

Re: If H1:h99 Equal b3 then f must say done.

What do you mean "everything above F11 equal done"

What cell did you put the formula in? What result did you expect? What result did you get?

 

[OXNARD208]

Re: If H1:h99 Equal b3 then f must say done.

Formula entered in f3:f99
Example:
Expected to enter the value in H16 that b7 has and for only F7 to have the value as DONE.

 

[OXNARD208]

Help on if a value from i2:i99 equal a value from b3:b99 then c must equal john
FYI
This formula is going to be for 5 Names so I cant write the formula on C.

Thank you,

 

[Gerald Higgins]

Wow this is vague

Can you give us more details please ?

Are you trying to check if ANY value in I2:I99 is found in B3:B99 ?

And if there are 5 possible names, how do we know whether to choose John, Jane, Mike, Mary, or Oxnard ?

 

[OXNARD208]

Sorry,
Heres my best example
For Example
A B C D E .. (f)JOHN (g)JANE (h)MIKE (I)MARY (j) OXNARD
1:25 JOHN .. 25 .......... 35 ..... 55 ....... 65
2:35 JANE .. 45
3:45 JOHN
4:55 MIKE
5:65 MARY

 

[OXNARD208]

Sorry,
Heres my best example
If f1 equal a1 then b must equal John or if f2 equals a3 then b must equal Jane
For Example
....A ... B .... C ... D.. E .. (f)JOHN (g)JANE (h)MIKE (I)MARY (j) OXNARD
1:25 JOHN ...................... 25 .......... 35 ..... 55 ....... 65
2:35 JANE .. ................... 45
3:45 JOHN
4:55 MIKE
5:65 MARY

 

[Tetra201]

Try the following array formula (to be entered using Ctrl+Shift+Enter, not just Enter):

=IFERROR(CHOOSE(MAX(IF($F$1:$J$2=A1,COLUMN($F$1:$J$2)-COLUMN($E$1))),"JOHN","JANE","MIKE","MARY","OXNARD"),"Not Found")