ibrahimdaas
New Member
- Joined
- Sep 1, 2014
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
I have three sheets, A, B , C.... Where in A I have values for all my products, in B I have the sold products, , in C I have
the rest of the value which is the unsold products, all the values are scattered randomly on every sheet.
Now I if I wanted to add a column in the sheet: A, that will till me when the value is SOLD/NOTSOLD .... so that at the end I can look at this sheet and know
what is sold and what is not
how I can do that... is there a right way with the use of INDEX & MATCH?
the rest of the value which is the unsold products, all the values are scattered randomly on every sheet.
Now I if I wanted to add a column in the sheet: A, that will till me when the value is SOLD/NOTSOLD .... so that at the end I can look at this sheet and know
what is sold and what is not
how I can do that... is there a right way with the use of INDEX & MATCH?
Last edited:
