Paul

If you're still following this thread please note I received your email and
saved the vlookup.txt file but<sheepish grin managed to lose the the email with
description of what you want for results and your return address..

Please re-send.

Thanks, Gord

On Wed, 22 Aug 2007 15:49:50 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Paul

For VLOOKUP you need a lookup value, a lookup array and a column within that
array.

First of all I would break the sheet1(lastname, firstname,middle initial)cell
into into 3 columns using DataText to Columns so you can look for the actual
value in a cell.

I don't understand what you want returned and where on sheet1 from sheet2

Values from sheet2 returned to which cells on sheet1?

Your original post had different data and layout.

Changing examples in midstream is too confusing this old guy.

You could send me your workbook if you want.

Change the AT and DOT in my email address to send to me.


Gord

On Wed, 22 Aug 2007 15:12:01 -0700, Paul wrote:

Hi, not sure I understand the formula but on sheet 1 in cell D4 I have the
name as (lastname,firstname,middleinitial) that I want to search on sheet 2
but the name is listed as first name,lastname,middle initial. On the second
sheet I have columns as follows
A B C D E
lastname firstname position salary boss

on sheet 1 I need the boss so I tried
VLOOKUP(D4,SHEET2!E2,1,FALSE) which creates an error.
I would like to search through 20 rows in column E
I think the error may be because of the way the total name
(lastname,firstname,middleinit) is combined into 1 cell on sheet 1
and they first and last names are listed in seperate cells on sheet2.
Thanks.