Please help with matching spreadsheets
I have two spreadsheets with file numbers in column A. I need to know if the
files on spreadsheet 1 (named 2008) are located on spreadsheet 2 (named RS). If so, I need to put a 1 in the column I'm entering the function (column "U", since columns B through T have different data). Any immediate help would be appreciated. Thank you. Joe (muggle) |
Please help with matching spreadsheets
Perhaps something like this:
=IF(ISNUMBER(MATCH(2008!A1,RS!A:A,0)),1,"") -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JoeL" wrote: I have two spreadsheets with file numbers in column A. I need to know if the files on spreadsheet 1 (named 2008) are located on spreadsheet 2 (named RS). If so, I need to put a 1 in the column I'm entering the function (column "U", since columns B through T have different data). Any immediate help would be appreciated. Thank you. Joe (muggle) |
All times are GMT +1. The time now is 04:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com