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
This is a photo of where the result needs to be displayed.
Fig.2
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?
This is a photo of where the reference needs to come from.
Fig.1
HTML:
"http://i5.photobucket.com/albums/y168/Tr0n1x/excel2.jpg"
Fig.2
HTML:
"http://i5.photobucket.com/albums/y168/Tr0n1x/excel1.jpg"