VLOOKUP and invalid cell reference error

[ChrisCione]

Good morning,

I have this formula in cell K28 on one worksheet in Excel 2007

=VLOOKUP(K26,DataTables!K2:K31,3,TRUE)

K26 refers to a cell containing an individual's name (which can and will vary). I K28, I want to have an email address.

The "DataTables" worksheet contains the following info:


Column K: Names of various Individuals
Column M: Corresponding email addresses of each individual
Column u: Corresponding phone numbers

K........................M............................U
John Smith jsmith@email.com......555-213-5689
Charlie Jones cjones@email.com......555-789-1265

The objective:

Excel matches the name in K26 in worksheet 1 to the corresponding email address on the second worksheet, and enters into K28. And I want to do same for the phone number.

Formual is returning invalid cell reference error. I've read and read and read, but can't figure it out. Suggestions?

 

[Chris Mack]

The formula for the phone number is returning the error? What formula are you using?

 

[steve the fish]

The formula is incorrect.

Try:

=VLOOKUP(K26,DataTables!K2:U31,3,FALSE) for email
=VLOOKUP(K26,DataTables!K2:U31,11,FALSE) for phone num

 

[ChrisCione]

Thanks, Steve.