Please help me !!!! WITH VLOOKUP, MATCH , INDEX ........

B

bftznk

New Member
Joined
Apr 17, 2013
Messages
16
Hi all,
I am stuck on excel again,

What I am trying to do is matching the result and name in different month
1 MONTH AND NAME WILL BE IN PUT MANULLY
2 SHOULD I USE VLOOKUP MATCH , INDEX OR SOMETHING ELSE?:ROFLMAO:


ABCDEFGHIJKL
1 MONTHNAMERESULT1RESULT2RESULT3
21JANA0.8194520.914580.061559
3 B0.6048470.2040470.272456
4 C0.3560550.04920.72544 INPUT
5 D0.1718490.2571190.666312 MONTH2
6 E0.4281710.1969430.615605 NAMEC
7 F0.8223860.0199960.17076 RESULT 1
8 G0.3381010.1550480.474083 RESULT 2
9
10
11
12
13
142FEBA0.8385320.9852740.287719
15 B0.2269380.2775340.538367
16 C0.2967840.5871320.069183
17 D0.44150.1653030.609791
18 E0.7131510.3087440.189958
19 F0.2345230.0156180.744492
20 G0.7880120.8019310.718554
21
22
23
24
253MARA0.4667630.066520.096242
26 B0.4658330.9934450.27822
27 C0.6013960.5416910.076991
28 D0.5043480.6544650.539561
29 E0.0250890.8195510.199993
30 F0.1201180.1297610.00493
31 G0.4823790.9738420.153111

<TBODY>
</TBODY>
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Sort by date Sort by votes
Are you able to make a slight change to the layout of your data? Can populate the month number in the empty cells (A3:A8, A15:A20, A26:A31)?

If so, you can use the following formula in K7 (confirm with ctrl+shift+enter) and then copy to K8:
=INDEX($D$2:$F$31,MATCH($K$5&$K$6,$A$2:$A$31&$C$2:$C$31,0),MATCH(J7,$D$1:$F$1,0))
 
Upvote 0
Try this in K7 filled down to K9

=OFFSET(INDEX($D$2:$F$8,MATCH($K$6,$C$2:$C$8,0),MATCH(J7,$D$1:$F$1,0)),MATCH($K$5,$A$2:$A$32,0)-1,0)
 
Upvote 0
bftznk said:
....thx but still doesn't work
Click to expand...

Both formulae work as expected (Jonmo's is preferable since you don't need to amend your data). Note that your headers in row 1 don't contain a space ("RESULT1") while your criteria do ("RESULT 1")
 
Upvote 0
bftznk said:
....thx but still doesn't work
Click to expand...

What do you mean 'Still' ? This was the first attempt.
Oh wait, no it's not.

http://www.mrexcel.com/forum/excel-questions/699467-huge-problem-index-match-lookup.html#post3456191
http://www.mrexcel.com/forum/excel-questions/698267-another-problem-than-hard-rock.html#post3450977

You really should stick to 1 thread for the same issue.
If you're not getting responses, you can 'bump' the original thread once in a while to get more views.
 
Upvote 0
FYI, I have now locked the other two threads.

As Jonmo said, please stick with one thread.
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,215,053
Messages
6,122,882
Members
449,097
Latest member
dbomb1414

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top