Excel VBA : Vlookup/index match with various value in column and row

A

Anuar malik

New Member
Joined
Apr 9, 2018
Messages
1
Hi guys,
I'm very new in this excel VBA. I have a problem with this table. see the picture

This is sheet1 = all the data will be here.
AgMn2.png


this is sheet2: only the selected element will show. the problem is, i don't know how to link/get only the selected value data to show in sheet2.

cEQ9A.png


I tried to use Vlookup/ index match but it's not working. u can download the excel file using this link.
https://drive.google.com/open?id=1iKSztpUjTW_qaRhJtlDt2aN3an3whxok Thanks.
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
You must log in or register to reply here.

Similar threads

H
  • Question Question
Help - #unknown! error after adding pictures.
Replies
1
Views
1K
myall_blues
myall_blues
N
  • Question Question
VBA loop to duplicate sheets between one existing excel file and anew one
Replies
2
Views
122
ND1979
N
N
  • Question Question
Match and show the data from 2 sheets
Replies
3
Views
199
kvsrinivasamurthy
K
L
  • Solved
Index and Match
Replies
5
Views
379
Lizzi
L
R
  • Solved
Msbox VBA code when cell value is changed
2
Replies
18
Views
514
Ramadan2512
R

Forum statistics

Threads
1,223,987
Messages
6,175,795
Members
452,670
Latest member
nogarth

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