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

**sinha1111** · 02-06-2012, 05:47 AM

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** · 02-06-2012, 05:49 AM

Try

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

**TMShucks** · 02-06-2012, 05:55 AM

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

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

Thread Tools

Display

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

Re: For every change in the value of a cell, return another value in the adjacent cel

Re: For every change in the value of a cell, return another value in the adjacent cel

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions