MATCH and TYPE

[gkhnr10]

Hi guys,

I attached an example excel sheet. I tried to figure out but could not get a way. I need a formula which takes the value in D2, search it in column A, if the value is in the list, type the corresponding result in E2.

In our example in E2 would be ''no''.

I highly appreciate if you can help me with this.

Thanks beforehand.

Gokhan.

Example.xlsx

[Pete_UK]

Put this formula in E2:

=IFERROR(VLOOKUP(D2,A$2:B$9,2,0),"")

then copy down. It will return a blank if the item in column CD is not in the list in column A.

Hope this helps.

Pete

[Amik555]

Hi,

try this formula in E2:
=IFERROR(VLOOKUP(INDEX($A$2:$A$9;MATCH(D2;$A$2:$A$9;0));$A$2:$B$9;2);"Not in the list")

[gkhnr10]

Hi Pete,

Thank you it has worked.

Is that possible to go one more step ? To take the final result we get in E2 and type it in other excel sheet ?

Would that work between two independent excel sheet ?

Thanks.

[Pete_UK]

Yes, suppose you have columns A and B in Sheet1 and the list that is currently in column D is in column A of Sheet2. Then you can use this formula in B2 of Sheet2:

=IFERROR(VLOOKUP(A2,Sheet1!A$2:B$9,2,0),"")

Hope this helps.

Pete

[gkhnr10]

I will try this and will give you a feedback as soon as possible.

Thanks.

[gkhnr10]

I've changed to formula according to my original excel sheet and it works totally.

Thank you again for your help and quick reply.

Gokhan

[Pete_UK]

Glad to be able to help - thanks for the rep.

Pete