IF cell = "string" Display a corresponding cell

[Barrelroll]

Hi all,

I'm not sure if this is possible but it since I've joined Excel Forum it seems like anything in Excel is possible lol.

IF A1 = "String"
Display corrasponding cell B1

It's a little more complicated then it sounds, please see attached example.

Thanks!

[NBVC]

If I understood you correctly, then put in E3:

=COUNTIF($C$4:$C$11,E2) and copy to F3,

Then in E4 put:

=

Please Login or Register  to view this content.

confirm this formula with CTRL+SHIFT+ENTER not just ENTER and then copy it to next column and down as far as you need.

This will extract the Areas for which B has the corresponding Type

[mikerickson]

You could select E4:E25 and enter the array formula

=INDEX($B:$B,SMALL(IF($C$4:$C$100=E2,ROW($C$4:$C$100),999),ROW($1:$100)),1)&""

Selecting E4:F25 and filling right will take care of the second column.

This formula needs to be entered with Ctrl-Shift-Enter (Cmd+Return for Mac)

[Barrelroll]

If I understood you correctly, then put in E3:

=COUNTIF($C$4:$C$11,E2) and copy to F3,

Then in E4 put:

=

Please Login or Register  to view this content.

confirm this formula with CTRL+SHIFT+ENTER not just ENTER and then copy it to next column and down as far as you need.

This will extract the Areas for which B has the corresponding Type

Damn you guys are good! lol
Thank you very much for that.