If Function with 2 Separate Ranges

[snaplink22]

Hello,

I am attempting to return a value from a range of cells, based off another range of cells. Here's an example of what I would like to do:

Tab 1
A1 - Is one of ten hand-keyed in options (cancel, order, hold, etc.)
B1 - Returns a date from a range of dates located on a second tab, based on the value of what is in A1

Tab 2
A1 - Contains all of the 10 options that can be keyed into cell A1 on Tab1
B2 - Each option in cell A1 has a corresponding date next to it.

Order 7-5-18
Hold 7-12-18
Cancel 7-15-18

So when I input 'Order' in to A1 on Tab 1, B1 on Tab 1 returns a value of 7-5-18.

Any help on this matter is greatly appreciated.

 

[Eric W]

Welcome to the board.

Try in B1:

=VLOOKUP(A1,Sheet2!A1:B10,2,0)

I assume you mean that Order is in A1, Hold is in A2, Cancel is in A3, etc. If all the values are in A1, that's a much tougher option, and I'd recommend putting them in different cells.

 

[snaplink22]

Thank you Eric. I can't believe I didn't think about a simple vlookup to get what I wanted, d'oh!

 

[Eric W]

Sometimes it just takes another set of eyes. Glad to help!