Possible Index/IF Function

[jdavis971]

I am trying to figure out the formula where I need a cell to auto populate a result based on the input of another cell.

For example. Column A (Region) will be the cell that will have the input. Column B (Destination Location) is the cell that I would like to auto populate based on the input in column A. Any help would be greatly appreciated

Region	Destination Location
North Alabama	Vernon Hub
South Mississippi	Magnolia Hub
North Louisiana	West Monroe
North Mississippi	Direct

 

[kweaver]

Welcome.

How does Excel know what the destination is? Is that in another table somewhere?

 

[jdavis971]

I should have been more clear. The formula would be in column B (Destination location), I was just showing that there could be multiple inputs, and based on the input, it could be a variety of outputs.

 

[kweaver]

I still don't know how a formula in the B column could determine the destination unless there's a correspondence table somewhere.

 

[jdavis971]

I still don't know how a formula in the B column could determine the destination unless there's a correspondence table somewhere.

Yes, there would be a corresponding table.

 

[kweaver]

Well, in order to show you an appropriate formula, it would be necessary to see the table!

 

[Peter_SSs]

Yes, there would be a corresponding table.

So... something like this?

23 06 30.xlsm
	A	B	C	D	E	F
1	Region	Destination Location			Region	Destination Location
2	North Alabama	Vernon Hub			North Alabama	Vernon Hub
3	South Mississippi	Magnolia Hub			North Louisiana	West Monroe
4	North Louisiana	West Monroe			North Mississippi	Direct
5	North Mississippi	Direct			South Mississippi	Magnolia Hub
Lookup

Cell Formulas
Range	Formula
B2:B5	B2	=XLOOKUP(A2,E$2:E$5,F$2:F$5)

 

[jdavis971]

That worked. Thank you so much.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.