Formula Help

[narikisas]

Hi,

I need help in this formula

In column A, I have name of the individuals. In column H i have a list of names [H1:H50].
In column B i need to insert a formula which looks the value corresponding in column A, should search the value in the range of cells of column H [H1:H50] and if present should copy the corresponding name of column A to the cell in column B

Please help.

Thanks in advance.

Below is the example

Col A Col B Col H
Mary =Formula X
Bob Bob [Result of formula] Y
Sam Z
Peter Bob
David V
Samuel
A
B
C
D
E
F

[Pete_UK]

Your example isn't much help, but from your description I think you need a formula like this in B2:

=IF(ISNA(MATCH(A2,H$1:H$50,0)),"",A2)

then copy it down.

Hope this helps.

Pete

[narikisas]

Hi Pete,

Thank you for the formula. But I am actually facing difficulty while trying to combine the formula with another.

Let me explain you the actual requirement so that you can help me in correcting where i am going wrong.


I have column A as Group, column B as names of individual, column C would need the formula.

If group in column A is equal to "GM" or "Support" and value in column B is within the range of values in column H [H1:H50], then copy the corresponding value in column B to column C.

This is the formula I am using which is not giving the required result

=IF(AND(OR(A2="GM",A2="Support"),ISNA(MATCH(B2,H1:H50,0))),B2, "")

Thanks

[tigeravatar]

Give this a try:
=IF(AND(OR(A2={"GM","Support"}),ISNUMBER(MATCH(B2,$H$1:$H$50,0))),B2,"")

[shg]

Welcome to the forum, narikisas

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

[narikisas]

Thank you tigeravatar It worked

[royUK]

Narikisas
Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore Moderators' or Administrators' requests - note that this includes requests by senior members as well, if you are unclear about their request or instruction then send a private message to them asking for help. Do not post a reply to a thread where a moderator has requested an action that has not been complied with e.g Title change or Code tags...etc