Help regarding MS Excel

sato1986

sato1986

Level G
Hi folks,

I need to compare two sets of columns and show the gain/loss in a new column.



Kindly tell me a way to compare coulmn set AC with GH and show result in KL

TIA
 
well .. i can help you with this mate.. but a little more explanation of what you exactly need.. didnt understand the space thing that you want if values dont match???
 
I have created one file as per your requirements with relevant formulas. Cant upload .xlsx file here(forum does not support), please share your email, will mail you.
 
Are article number and item number supposed to be the same. What are you trying to do, could you explain more in detail. In K2 you will input an ITEM NUMBER, then what is pulled from column G to compare the price too..?
 
^^

I do not think he wants to have it 'looked up'. Or does he want it compared only opposite to the line item. He needs to tell us, else this exercise is futile.

Also in "M", your vlookup array is moving...! ;)
 
THIS: as @asingh already mentioned, is the issue. Fix it (the first row needs to look something like =IFERROR(VLOOKUP(K2,$G$1:$H$34,2,0),"NIL"), and then drag / double click the complete handler on the bottom right to get the rest of the rows) and you will have the right %s.

asingh said:
Also in "M", your vlookup array is moving...! ;)
Click to expand...
 
This will do it in one go, and return a " ", if the value is not present.

=IF(ISERROR(VLOOKUP(A2,$G$2:$H$14,2,0))," ",(VLOOKUP(A2,$G$2:$H$14,2,0)-C2)/C2)
Click to expand...

The array depth is 14, which you can extend if you want.
 
sato1986 said:
This is what I was looking for. Comparing the old price with new price, and inserting (space or N/A) for the items which arent in the new price list & vice-versa.

Il try implementing the same in my sheet.
Click to expand...

Glad, it helped :)
 
Back
Top