Hello everyone,
Here is what I am trying to accomplish.
Based on Column A or ORDER_NOTE I need to find the respective match in
column C.
It perfectly works for 1 match.
What if I have three or more matches how to force excel to look for
others?
This formula is inside of macro.
I can use count function to find out how many times 'ORDER_NOTE'
appeared.
ActiveCell.FormulaR1C1 =
"=LOOKUP(""ORDER_NOTE"",Range(""A:A""),Range(""C:C ""))"
Also, is it possible to concatenate all the finding of column C that
match 'ORDER_NOTE' in column A?
Also, is there a way to assign an address a cell?
Thank you,
Sonya
--
Sonya795
------------------------------------------------------------------------
Sonya795's Profile:
http://www.excelforum.com/member.php...o&userid=26110
View this thread:
http://www.excelforum.com/showthread...hreadid=394561