[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

excel macro

Posted on 2014-04-04
3
Medium Priority
?
283 Views
Last Modified: 2014-04-04
Hello,

I need help with excel macro.
Please see attached file.
What I need is:
1. look in spreadsheet and if A2 & B2 = G (any) & H (any) take correct (I) and put in E2, loop,
check another record etc.
I have around 200 records both sections.
Example,
A2=1a
B2=CR
match
G5, H5
put 1 into E2

thanks
test.xlsx
0
Comment
Question by:henryk123
  • 2
3 Comments
 
LVL 24

Accepted Solution

by:
Ejgil Hedegaard earned 2000 total points
ID: 39978941
No need for VBA, a formula can do it.
=SUMPRODUCT(($G$2:$G$12=A2)*($H$2:$H$12=B2)*$I$2:$I$12)
0
 

Author Comment

by:henryk123
ID: 39978969
hmm......
What can I say, FANTASTIC !!!

thanks
0
 

Author Closing Comment

by:henryk123
ID: 39978971
Great Job.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question