Hi all,
this is doing my head in.
What I'm trying to do is: if name in A2 is in Sheet1!A:A and value in B1 is in Sheet1!I:I (same row) return Yes, otherwise leave blank.
I tried different approaches using MATCH, VLOOKUP, IF but cannot figure it out.
All my attempts do is return yes if A2 is in Sheet1!A:A
I have attached example spreadsheet of the data
This is layout of data
<tbody>
</tbody>
and this what I want the result to look like.
<tbody>
</tbody>
What I tried: =IF(MATCH(A2,Sheet1!$a$2:$a$4,0)*MATCH($b$1,Sheet1!$b$2:$b$4,0),"yes","")
This is small example of what I'm doing, will have to apply this to bigger sets of data and multiple worksheets, but I just can't figure out right approach to MATCH function in this case.
All your help will be appreciated
this is doing my head in.
What I'm trying to do is: if name in A2 is in Sheet1!A:A and value in B1 is in Sheet1!I:I (same row) return Yes, otherwise leave blank.
I tried different approaches using MATCH, VLOOKUP, IF but cannot figure it out.
All my attempts do is return yes if A2 is in Sheet1!A:A
I have attached example spreadsheet of the data
This is layout of data
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> |
<tbody> </tbody> | ||
<tbody> </tbody> | John Black |
<tbody>
</tbody>
and this what I want the result to look like.
Name | Cat1 | Cat2 | Cat3 |
Martin Kelly | Yes | Yes | |
Mark Henry | Yes | Yes | |
John Black | Yes |
<tbody>
</tbody>
What I tried: =IF(MATCH(A2,Sheet1!$a$2:$a$4,0)*MATCH($b$1,Sheet1!$b$2:$b$4,0),"yes","")
This is small example of what I'm doing, will have to apply this to bigger sets of data and multiple worksheets, but I just can't figure out right approach to MATCH function in this case.
All your help will be appreciated