Y
Yajiv
I have two sheets "sheet1" and "sheet2"
In both sheets I have two columns called "id" and "status"
In sheet1, in column id I have unique numbers.
the status in sheet2 will be updated very often.
I want to update the same status to corresponding id in sheet1.
sheet2 will only have id's whose status has changed recently. not all
the ids will be available in sheet2. so i can't sort and copy it to
sheet1.
How to do this with formula alone? Kindly revert back for
clarifications.
In both sheets I have two columns called "id" and "status"
In sheet1, in column id I have unique numbers.
the status in sheet2 will be updated very often.
I want to update the same status to corresponding id in sheet1.
sheet2 will only have id's whose status has changed recently. not all
the ids will be available in sheet2. so i can't sort and copy it to
sheet1.
How to do this with formula alone? Kindly revert back for
clarifications.