Referencing a specific cell.......

[Doug12]

I need to know if there is a way to reference a specific cell on a row based on a matched text string in a column.

This is a photo of where the reference needs to come from.

Fig.1

"http://i5.photobucket.com/albums/y168/Tr0n1x/excel2.jpg"

This is a photo of where the result needs to be displayed.

Fig.2

"http://i5.photobucket.com/albums/y168/Tr0n1x/excel1.jpg"

So what i want in cell B2 (Fig.2) is what matches A2 (Fig.2) In column B in the first photo but I want to display whats in Column A (Fig.1) in the same row that a match is found. Is there a formula that can do this?

 

[VoG]

This is unclear as we don't know what your sheets are called. Perhaps something like

=VLOOKUP("A3",'Sheet2':A1:J12,5,FALSE)

 

[Doug12]

The name of the first sheet is Test the second is Teacher.

Here is a picture of what should be displayed if the formula worked.
<img src="http://i5.photobucket.com/albums/y168/Tr0n1x/Excel3.jpg" border="0" alt="Photobucket">

 

[xenou]

Some combination of index and match might be needed (since you are returning a value to the Left of the lookup column):

maybe:
=INDEX(Test!A1:A10,MATCH(A2,Test!B1:B10,0),1)

(where I've assumed 10 rows but your data is certainly more than 10)

 

[Doug12]

Thank you! Worked like a charm