Help! Trying to Create an Excel Formula

[waileagolfer]

Hi,

I'm trying to figure out a formula. How do I:

In a single workbook, I want a cell in one sheet to look at another cell in another sheet and depending on the value (A, B, C), return a result from another cell in a third sheet.

In other words:

In sheet 1, L5 is where I want the final result to show up.

Using L5 in sheet 1, if I look at a cell in sheet 2 (O14) and it says "A", then I want it to give me a result in sheet 3 (C4). If the cell in sheet 2 (O14) says "B", then I want it to give me a result in sheet 3 (C5). If the cell in sheet 2 (O14) says "C", then I want it to give me a result in sheet 3 (C6).

How do I write this formula?

Thanks for any help!

[#2 · Accepted solution]

@waileagolfer 

In L5

=IFS('Sheet 2'!O14="A", 'Sheet 3'!C4, 'Sheet 2'!O14="B", 'Sheet 3'!C5, 'Sheet 2'!O14="C", 'Sheet 3'!C6, TRUE, "")

or

=IFERROR(INDEX('Sheet 3'!C4:C6, MATCH('Sheet 2'!O14, {"A", "B", "C"}, 0)), "")

[#3]

@Hans Vogelaar 

Thank you!!! That worked. I really appreciate the help.