flummi wrote:
Make your lookup table look like this:

col 1___________col2________col3_________col4
SmithJohn______Smith_______John________any other data

If search name is in C3 and search first name is in D3 and your table
is in E3:H10:

For E3:E10 use this formula: =F3&G3 and copy down.

For your lookup use this formula: =vlookup(C3&D3,E3:H10,5,false)

Regards

Thanks !!!

took me awhile but I got it to work

What about after copying down and data is not filled in the result is N/A how
do I get the result to indicate blank until data is complete.

thanks

Hans

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200603/1