How do you use the vlookup function to compare data on 2 different worksheets?

Posted by Dot on August 28, 2001 2:31 PM

How do you use the Vlookup function to compare datat from more than one worksheet?

Posted by Bob on August 28, 2001 2:56 PM

Try
=Vlookup(A2, Sheet2!A:A:sheet2!B:B,2,false)

Posted by Allan on August 29, 2001 4:21 AM

=IF(ISNA(VLOOKUP(C1,A1:B100,2)),VLOOKUP(C1,Sheet2!A1:B50,2),VLOOKUP(C1,A1:B100,2))