returning Specific Text

[USChad]

I have a spreadsheet with a few thousand rows. I need a formula that returns the information (it is text) from column D if the number in column B matches what I am looking for. I know how to do this with numbers and SUMPRODUCT but not with text.

I have attached an example. For instance i will have a seperate spreadsheet where I will want to return the infromation from column D (WINTERS) if the cell equals "1111"


Thanks for the help.

[Paul]

Hi USChad,

I'm not quite sure how you match information and return a value using SUMPRODUCT, at least not by itself, but it sounds like a standard VLOOKUP is needed.

=VLOOKUP("1111",Sheet1!$B$1:$G$4000,3,0)

This will look for "1111" in column B of Sheet1, and return the value from the third column over in the lookup range (column D).

=VLOOKUP("1111",Sheet1!$B$1:$G$4000,5,0)

This one would return a value from the fifth column in the lookup range (column F).