# Solved copy text in col L to cz2 corresponding to a value in colCY

November 21, 2012 at 22:29:18
Specs: Windows XP
 copy text in col L based on a no. in colCY

See More: copy text in col L to cz2 corresponding to a value in colCY

#1
November 22, 2012 at 02:50:38
 It is impossible to offer a solution based on they limited information you have provided. Please supply more detail, using full sentences.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

#2
December 15, 2012 at 04:45:52
 i have text data in col 'L' . In Col "CY' there is numerical data. I want to pickup the text in col 'L' corresponding to a numerical value in Col "CY' in cell CY1.ExCol L CY * I want to copy text in col L correspondingabc 1 to a number in Col Cy eg.2 in cell cy1wse 2 'wse' in this casexyz 5awe 3

Report •

#3
December 17, 2012 at 12:05:31
 Let's say you start with this:``` L CY 1 2 abc 1 3 wse 2 4 xyz 5 5 awe 3 ```This formula will return the value from Column L corresponding to the number in CY1, assuming that the number is found in CY2:CY5. If it isn't, the formula will return #N/A.=INDEX(L2:L5,MATCH(CY1,CY2:CY5,0),1)The INDEX function returns the value from the array L2:L5 based on the row_num and column_num arguments. The MATCH function is used to determine the row_num argument by matching the value in CY1 within the array CY2:CY5.The #N/A can be eliminated with an IF(ISNA( function.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.