Forum Discussion
Index / Match alteration
Hi Twifoo, thanks for the reply, I am not sure if you are asking or making a statement. If the value in column A is not found at all then no other checks need to be made and the Sal column can just be set to 0. What I need to happen is to look for the value that appears in A, in the G column, if there is a match and the Qty match then add in the Sal value from C in to column I. If the Qty in D is 0 then the Sal is also 0 no matter what the ID value in column G is.
- I made a declaration, not simply a a statement. Column A, based on your sample, is the basis from which values shall be retrieved. You cannot, and logic doesn’t allow you to, reverse the logic by insisting that, in certain instances, the lookup value will now become the lookup column.
It’s like going to a place you don’t know where, but you have an idea of its location. It now seems that you want the location, which you don’t know where, to give you an idea of the destination, which you also don’t know where.
There must be some pattern for a formula to work!My apologies Twifoo I wasn't quite sure from your initial response. In relation to my original question I am not looking to reverse logic by changing the lookup value to the lookup column. But I do see some issues in my original logic as well as a strange error I am not sure about.
As I mentioned columns A to D are my reference values and G to K is where I am updating the data to based on when the ID and Qty match or if Qty is 0 then Sal will be 0 no matter what the ID value says.
My example already does what I want it to do but what I have noticed is, if I add a new value to the ID column in the reference section column (A) it invalidates row 9 in where I am updating my data to which I don't understand where previously it was ok but new records added to the G to K section are fine. Hopefully my example will show where the issue is.
