extracting data

[stoke]

hi there,

i have a unique identifier in a1,sheet2 and need to extract the related data from sheet 2 - ie find in column a then extract related data in column b to b2,sheet2.

i have this:
=IF(ISNA(VLOOKUP(F2,datarange,2,FALSE)),'YTD RM 2002-2003'!F2,VLOOKUP(F2,datarange,2,'YTD RM 2002-2003'!F2))

and it's not returning the right results..........

thanks guys,

 

[Paul666]

In the second VLOOKUP you have no specified the FALSE statement at the end...

Just a thought!