HI ALL,
Could you please help me with formula which can give me result based on data from 2 different column.
<tbody>
</tbody>
I have data in 2 columns A and B, I need a formula which can lookup the data in entire column and provide me the results.
- if data against ID is "S" then "OK"
- if data against ID is "P. then "OK"
- if the data against ID is "S" and "P" then "Check" - (ID A506 has both P and S)
Thanks
Chandresh
Could you please help me with formula which can give me result based on data from 2 different column.
ID | Type |
A500 | S |
A500 | S |
A501 | P |
A501 | P |
A506 | P |
A506 | P |
A506 | S |
A506 | S |
A506 | S |
A506 | S |
<tbody>
</tbody>
I have data in 2 columns A and B, I need a formula which can lookup the data in entire column and provide me the results.
- if data against ID is "S" then "OK"
- if data against ID is "P. then "OK"
- if the data against ID is "S" and "P" then "Check" - (ID A506 has both P and S)
Thanks
Chandresh