Vlookup failed................. solve the mystery

syed_mushraf

Active Member
Joined
Oct 13, 2002
Messages
259
I have data as following :-

Roll# Name English Math Science
215 ABC 99 75 85
100 DEF 55 65 75
300 XYZ 85 95 99

I want to apply vlookup in the following by matching two keys simultenously but vlookup is faild to provide the required result.
Dear All,

I have a set of information like this:-

Roll# English Math Science
100 Vlookup Vlookup Vlookup
300 Vlookup Vlookup Vlookup
215 Vlookup Vlookup Vlookup

It would be appricieated if any body can help me.

Regards,
Musharraf
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

syed_mushraf

Active Member
Joined
Oct 13, 2002
Messages
259
I want to get the result by using this formula of Vlookup:-

FOR ENGLISH:
=VLOOKUP(Rol&English,<Range>,3,false)
FOR MATH:
=VLOOKUP(Rol&Math,<Range>,4,false)
FOR SCIENCE:
=VLOOKUP(Rol&Science,<Range>,5,false)

Problem is that how can I search by concotenate two cells and then find it a range which has matching keys in a separate form.

Plz help
 

syed_mushraf

Active Member
Joined
Oct 13, 2002
Messages
259

ADVERTISEMENT

Dear Sir,

I am very...........very much thankful to you for this kindness. It is working absolutely fine accroding to my requirement.

Rgds,
Musharraf
 

syed_mushraf

Active Member
Joined
Oct 13, 2002
Messages
259
Can u plz explain told me how did you post this excel sheet on the message board. How can I do this.
 

straus

Board Regular
Joined
Oct 7, 2002
Messages
192

ADVERTISEMENT

click on "Colo's cool utility for displaying your Excel Worksheet on the board." and downmoad the software. then all the instructions are given as to how to proceed
 

syed_mushraf

Active Member
Joined
Oct 13, 2002
Messages
259
Dear experts I need your help. again I am stuck with this formula.
i have two data ranges as following.

Range-1
Item Week Site Data
21110 42 FCL 100
21110 43 UDL 50
21112 44 FCL 40
21113 42 FCL 200
21110 41 ASL 150
21112 43 UDL 303
21113 43 UDL 88


Range-2 Site Wk# Wk# Wk# Wk# Wk#
42 43 44 45 46
21114 FCL
21110 UDL
21112 ASL
21113 UDL
21112 FCL

My requirement is to fill data in the range-2 by considering 2 column given left in range-2. Plz help me how can I use SUMPRODUCT/VLOOKUP/MATCH/INDEX to get the desired result.
Rgds,
Musharraf
 

Forum statistics

Threads
1,148,397
Messages
5,746,460
Members
424,021
Latest member
naimathulla

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
Top