LinkBack URL
About LinkBacks
As attached sample, I want to put the value in the C column to column F , if the column A and B match with column D and E.
As attached sample, I want to put the value in the C column to column F , if the column A and B match with column D and E.
Last edited by naflas; 10-29-2010 at 01:07 AM.
How about:
=IF(AND(A1=D1,B1=E1),C1,"")
No...Originally Posted by MarvinP
coulmn A and B have 9000 rows and coulmn D and E have only 300 rows.
Here you go.
Note: the value will work as is. e.g.
Please Login or Register to view this content.Please Login or Register to view this content.i hope this makes sense?Please Login or Register to view this content.
Last edited by pr4t3ek; 10-28-2010 at 09:04 PM.
--
Regards
PD
----- Don't Forget -----
1. Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
2. Thank those who have helped you by Clicking the scales above each post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
then under your original criteria =IF(A1:B1=D1:E1,C1,"") would result in some matches up to rows 300 and thereafter when column A:B was showing "" Blank.
What would be your expected answer after rows 300?
Windows 7 using Office 2007 & 2010
Remember your [ code ] [ /code ] tags, makes reading soooo much easier
Hi ,
After 300 rows its balnk
how did my code go naflas?
Thanks for your answer.Here you go.
Note: the value will work as is. e.g.Please Login or Register to view this content.Please Login or Register to view this content.i hope this makes sense?Please Login or Register to view this content.
When I run it gives "run time error '13""
Type mismatch
the values in the coulmns have as follows
war.frs.001
BUD-458
...
..
can you post your workbook because i tested this based on the workbook that you gave me and it worked fine.
Hi Guys,
Reading the code above with the
Made me wonder if all three variables would be Dimed as Strings. The answer is - Only the Last and perhaps the reason for runtime error.Please Login or Register to view this content.
Read http://www.cpearson.com/excel/declaringvariables.aspx
Section of Pay Attention To Variables Declared With One Dim Statement
Error on the following lineHi Guys,
Reading the code above with the
Made me wonder if all three variables would be Dimed as Strings. The answer is - Only the Last and perhaps the reason for runtime error.Please Login or Register to view this content.
Read http://www.cpearson.com/excel/declaringvariables.aspx
Section of Pay Attention To Variables Declared With One Dim Statement
If ci.Value = tempvalue1 And ci.Offset(0, 1).Value = tempvalue2 Then
my code is assuming it looks exactly the same as your example workbook. like i said, please paste your workbook for a quick solution.
Hi ,
I can not sen the docuement. Your code is work ing fine with the docuement I attached. But the problem is when include 9000 rows in to coulmn A and B it gives error
try this
Please Login or Register to view this content.
Solved , ur the number 1.
Thank u so much
no probs, cheers boss!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks