If formula

[JohnDear]

Can someone help me create a formula using excel 2010
If column A = Michael Smith, and Column B= Credit then what State is listed in Column C for Michael Smith
Note - data is listed on Sheet 3 and summary is listed on sheet 4 if that helps.

[alansidman]

Perhaps a Vlookup.

Here is a tutorial: http://www.techonthenet.com/excel/formulas/vlookup.php

Alan

[finny388]

Try an array formula:

=INDEX(C:C,MATCH("Michael Smith" & "Credit",A:A&B:B,0))
When you are finished typing you must use Ctrl-Shift-Enter instead of just Enter.

This will create curly brackets around it to show it is an array formula.

If you don't see the curly brackets just go into edit the cell and hit ctrl-shift-enter

[JohnDear]

The following formula works thanks to you help:
{=INDEX(‘Sheet3’!C:C,MATCH(“Michael Smith”&“Credit”,‘Sheet3’!A:A&‘Sheet3!’B:B,0))}
But one more question – I also have the names listed on sheet 4 where the formula is located. Can I use for example A6 instead of the actual name so when I copy the formula down no need to change names

[finny388]

absolutely
try it

[JohnDear]

Works Great Thanks for your help