Compare rows of data in Excel

February 18, 2011 at 20:01:22
Specs: Windows XP
Column A Column B Column C Column D
Prd1 Com1 24 12
com1 prd1 12
com1 prd2 6

In column D, I want to drop in the value of the combination of com1 & prd1, which is 12

In other words, it should look for the reverse combination of column A & B and put the value in D


See More: Compare rows of data in Excel

Report •


#1
February 18, 2011 at 21:30:38
Thanks for telling us what you want.

If you need some help with that, feel free to ask.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 18, 2011 at 21:50:07
Column A	Column B	Column C	Column D
Prd1	Com1	24	12
Com1	prd2	12	
Com1	prd1	6	


Report •

#3
February 18, 2011 at 21:50:49
Hello
I have posted between the
tags..thanks a lot

Report •

Related Solutions


Ask Question