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

[syed_mushraf]

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

 

[Andrew Poulsom]

Post the formula that is failing.

 

[syed_mushraf]

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

 

[Andrew Poulsom]

See below:

BOOK3
	A	B	C	D	E
1	Roll#	Name	English	Math	Science
2	215	ABC	99	75	85
3	100	DEF	55	65	75
4	300	XYZ	85	95	99
5
6	Roll#	English	Math	Science
7	100	55	65	75
8	300	85	95	99
9	215	99	75	85
Sheet1

 

[syed_mushraf]

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]

Can u plz explain told me how did you post this excel sheet on the message board. How can I do this.

 

[straus]

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]

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

 

[syed_mushraf]

yes sir u alright but I am failed to get the result. Plz guide me. Many thanks.

 

[Aladin Akyurek]

yes sir u alright but I am failed to get the result. Plz guide me. Many thanks.

http://www.mrexcel.com/board2/viewtopic.php?p=304619#304619