Help! Trying to Create an Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2669912%22%20slang%3D%22en-US%22%3EHelp!%20Trying%20to%20Create%20an%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2669912%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20trying%20to%20figure%20out%20a%20formula.%20How%20do%20I%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20a%20single%20workbook%2C%20I%20want%20a%20cell%20in%20one%20sheet%20to%20look%20at%20another%20cell%20in%20another%20sheet%20and%20depending%20on%20the%20value%20(A%2C%20B%2C%20C)%2C%20return%20a%20result%20from%20another%20cell%20in%20a%20third%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20other%20words%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20sheet%201%2C%20L5%20is%20where%20I%20want%20the%20final%20result%20to%20show%20up.%3C%2FP%3E%3CP%3EUsing%20L5%20in%20sheet%201%2C%20if%20I%20look%20at%20a%20cell%20in%20sheet%202%20(O14)%20and%20it%20says%20%22A%22%2C%20then%20I%20want%20it%20to%20give%20me%20a%20result%20in%20sheet%203%20(C4).%20If%20the%20cell%20in%20sheet%202%20(O14)%20says%20%22B%22%2C%20then%20I%20want%20it%20to%20give%20me%20a%20result%20in%20sheet%203%20(C5).%20If%20the%20cell%20in%20sheet%202%20(O14)%20says%20%22C%22%2C%20then%20I%20want%20it%20to%20give%20me%20a%20result%20in%20sheet%203%20(C6).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20write%20this%20formula%3F%3C%2FP%3E%3CP%3EThanks%20for%20any%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2669912%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2670337%22%20slang%3D%22en-US%22%3ERe%3A%20Help!%20Trying%20to%20Create%20an%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2670337%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1133430%22%20target%3D%22_blank%22%3E%40waileagolfer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20L5%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIFS('Sheet%202'!O14%3D%22A%22%2C%20'Sheet%203'!C4%2C%20'Sheet%202'!O14%3D%22B%22%2C%20'Sheet%203'!C5%2C%20'Sheet%202'!O14%3D%22C%22%2C%20'Sheet%203'!C6%2C%20TRUE%2C%20%22%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eor%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIFERROR(INDEX('Sheet%203'!C4%3AC6%2C%20MATCH('Sheet%202'!O14%2C%20%7B%22A%22%2C%20%22B%22%2C%20%22C%22%7D%2C%200))%2C%20%22%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 Replies

@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)), "")

@Hans Vogelaar 

 

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