Excel 2007 : For every change in the value of a cell, return another value in the adjacent cell

[sinha1111]

I want to return a value in a cell based on the values in a range of cells, Please see the attachement for your reference and guide for the right formulae that I can write to achieve this result.

[Bob Phillips]

Try

=IFERROR(INDEX({18001022222,18001044444,18001066666,18001088888},MATCH(A2,{"Name 1","Name 2","Name 3","Name 4"},0)),"Not Found")

[TMS]

That looks like a requirement for VLOOKUP.

On a separate sheet, list the names and the associated calues/codes.

Assuming the list were in Sheet2, it would look something like this:

=IFERROR(VLOOKUP($A2,Sheet2!$A:$B,2,FALSE),"Not Found")


Regards, TMS