Thanks again Bruce,

I seem to be making an omission when i'm explaining, i have names on
Sheet 2 in column E then 2 columns of data i then have names in column
H then 2 columns of data.......ect and so on until last column of data
in column P, on Sheet 1 i have groups of names (all of which appear on
Sheet 2) and in the cell to the right of each name i want to return the
value of the cell on Sheet 2 two columns away, so if it was Column E2
then the value of G2 will appear on Sheet 1.

Sorry for any cloudiness but i knew what i was trying to achieve but
the fingers wouldnt let me explain here!!!!!

I was currently trying
this...=IF(ISNA(VLOOKUP(A4,Find,3,FALSE)),0,(VLOOK UP(A4,Find,3,FALSE)))
as i need to return a value of zero if the name is not found or there is
no value in the cell we are looking to extract from.

Simon


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=465487