If formula

[vinumv]

Good Morning,

Here I would like to get your valued guidance for the usage of "IF" formula. I am having two sheets one is new XL-1 and other is old XL-2. I want to have a item number from the old file corresponding to the same item descprition in the new file.

I am attaching the snap shots of two files which is more explanatory than describing in words here.

Expecting your helping hand.

Vinu

[sglife]

I think this is what you need

Please Login or Register  to view this content.

[vinumv]

Thanks a lot, it works in wonderful way.