# Referencing a specific cell.......

#### Doug12

##### New Member
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
HTML:
``"http://i5.photobucket.com/albums/y168/Tr0n1x/excel2.jpg"``
This is a photo of where the result needs to be displayed.

Fig.2
HTML:
``"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?

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

#### VoG

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

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

#### Doug12

##### New Member
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">

Last edited:

#### xenou

##### MrExcel MVP
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

##### New Member
Thank you! Worked like a charm

Replies
5
Views
316
Replies
7
Views
107
Replies
2
Views
258
Replies
4
Views
222
Replies
4
Views
748

1,190,898
Messages
5,983,454
Members
439,843
Latest member
PlanetFitness

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back