Help with backwards lookup
 

Here's what I'm trying to do. I'm not sure if this is possible. On Sheet 2
I have column A named Ticker and Column B named Cusip number. I have all the
cusip numbers filled in. However, the correspondeing ticker for each is not.
I want to go out to Sheet 1 and find the ticker. However, sheet 1 has its
columns as: Column A (Ticker), Column B is called Description and Column C
is the Cusip number. The Cusip number column is not on the far left of sheet
1. Is it possible to do a lookup that will go to sheet 1 and get the ticker
of the corresponding cusip number? I know this is confusing. Any help is
appreciated.

Help with backwards lookup
 

With the table on Sheet2 and the cusip number to match in x99:

=index(sheet2!a:a,match(x99,sheet2!c:c,0))

Take a look at Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions03.html

XFILES wrote:

Here's what I'm trying to do. I'm not sure if this is possible. On Sheet 2
I have column A named Ticker and Column B named Cusip number. I have all the
cusip numbers filled in. However, the correspondeing ticker for each is not.
I want to go out to Sheet 1 and find the ticker. However, sheet 1 has its
columns as: Column A (Ticker), Column B is called Description and Column C
is the Cusip number. The Cusip number column is not on the far left of sheet
1. Is it possible to do a lookup that will go to sheet 1 and get the ticker
of the corresponding cusip number? I know this is confusing. Any help is
appreciated.

--

Dave Peterson