Hi,

I use Excel 2004 for Mac.

My question relates to a Lookup issue.

All data is contained within the same file.

On one spreadsheet I have data in two columns. In the first column I
have a name - in the second column I have personal details (phone
number and email address)

On a second spreadsheet I want to create a lookup formula that will
autofill a cell for me. What I would like to do is to type a person's
name into a cell and then have the cell next to it look up and then
autofill their person details. When I try and do this using the lookup
command I am getting N/A and NAME errors.

Help appreciated, Nik


--
Ntisch
------------------------------------------------------------------------
Ntisch's Profile: http://www.excelforum.com/member.php...fo&userid=5791
View this thread: http://www.excelforum.com/showthread...hreadid=382370