Solved

excel macro

Posted on 2014-04-04
3
262 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 20

Accepted Solution

by:
Ejgil Hedegaard earned 500 total points
Comment Utility
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
Comment Utility
hmm......
What can I say, FANTASTIC !!!

thanks
0
 

Author Closing Comment

by:henryk123
Comment Utility
Great Job.
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

763 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now