Hi,

I have a workbook with Spreadsheet1 and Spreadsheet2. I want to lookup
column E of Spreadsheet2 on Spreadsheet1, and if column K of
Spreadsheet1 is greater than or equal to 1, then highlight the row in
Spreadsheet2.

VLOOKUP won't work because the numbers are not in order.

Any suggestion?

Thanks,
Gos-C


--
Gos-C


------------------------------------------------------------------------
Gos-C's Profile: http://www.excelforum.com/member.php...o&userid=14518
View this thread: http://www.excelforum.com/showthread...hreadid=376278