Please help a clueless beginner: Is there a similar function to VLOOKUP for data containing all-text?

[leahw]

Hi, I wasn't able to find the answer to my question online and have no idea what I'm doing in Excel.

Out of a spreadsheet with thousands of company names and their associated data, I have a specific list of companies that I need email addresses for. Instead of manually searching for each one, is there a function I can use to determine the email addresses for me? I think I'm basically trying to do a VLOOKUP without any values.

Any help is appreciated.

 

[Z51]

VLOOKUP can search for many types of data, including both text and numbers.

For example:

=VLOOKUP("Bob Smith",A1:G100,4,0)

=VLOOKUP(134,A10:F22,6,0)

=VLOOKUP(A2,G1:M100,5,0)

Where A2 has a value that exists in the first column of the range, e.g. G1:G100.

 

[Mposwal]

PLease be more descriptive. Helpful for others to troubleshoot if you could please share the demo of data

 

[leahw]

VLOOKUP can search for many types of data, including both text and numbers.

For example:

=VLOOKUP("Bob Smith",A1:G100,4,0)

=VLOOKUP(134,A10:F22,6,0)

=VLOOKUP(A2,G1:M100,5,0)

Where A2 has a value that exists in the first column of the range, e.g. G1:G100.

Thank you so much. Your first example formula worked. I wasn't putting a "0" at the end and was instead entering "false."

 

[Peter_SSs]

I wasn't putting a "0" at the end and was instead entering "false."

Welcome to the MrExcel board!
Using FALSE instead of 0 is exactly the same, provided that you don't enclose it in quote marks.

22 08 09.xlsm
	A	B	C	D	E
1	Name	Age		42	42
2	Tom Jones	23
3	Bob Smith	42
Sheet2 (2)

Cell Formulas
Range	Formula
D1	D1	=VLOOKUP("Bob Smith",A1:B3,2,0)
E1	E1	=VLOOKUP("Bob Smith",A1:B3,2,FALSE)