Forum Discussion

reevesgetsaround's avatar
reevesgetsaround
Brass Contributor
Jun 22, 2022
Solved

MATCH formula help with Multiple worksheets

Hello all   I'm hoping someone can assist with what I believe is not too difficult a task.   All I need is a formula in C2 of Sheet1 which will look across the 3 other worksheets, and where it fi...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 22, 2022

    reevesgetsaround 

    That could be

    =IF( ISNA( MATCH( Sheet1!B2, Submitted!A:A, 0) ),
 IF( ISNA( MATCH( Sheet1!B2, 'In Progress'!A:A, 0) ),
 IF( ISNA( MATCH( Sheet1!B2, 'Not yet Started'!A:A, 0) ),
     "no such",
     'Not yet Started'!$A$1),
     'In Progress'!$A$1 ),
      Submitted!$A$1 )
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 22, 2022

reevesgetsaround 

That could be

=IF( ISNA( MATCH( Sheet1!B2, Submitted!A:A, 0) ),
 IF( ISNA( MATCH( Sheet1!B2, 'In Progress'!A:A, 0) ),
 IF( ISNA( MATCH( Sheet1!B2, 'Not yet Started'!A:A, 0) ),
     "no such",
     'Not yet Started'!$A$1),
     'In Progress'!$A$1 ),
      Submitted!$A$1 )

Resources