Index/Match

[hardeep.kanwar]

Hi! Experts

I have two Sheets. Sheets1 is a master Sheet And sheet2 in which i want Data from Sheet 1.

Pls see the Example of my Data

Now i want a Function like Vlookup =vlookup($A2,Sheet1!$A$2:$M$1924,COLUMN(),FALSE)

But in Index and Match Format

Right now i am using this one: INDEX(Sheet1!$B$2:$B$38,MATCH(Sheet2!$A$2:$A$1924,Sheet1!$G$2:$G$1924,0))

And My Requirement is from Column B to Column F

Is this Possible to Drag my INDEX/MATCH function and also get the Result in column C,D,E,F in Sheet2

Or i have to Enter Manually in column in C,D,E,F of Sheet2

Excel Workbook
	A	B	C	D	E	F
1	CustCode	Propno	NetworkName	PropName	MCity	State
2	221000000133	221000000133-1	Jind Cable Network	Ravinder Kumar	Jind	HARYANA
3	221000000232	221000000232-2	City Communication	Arjun Sharma	Ferozepur	Punjab
4	221000000232	221000000232-3	City Communication	Parshotam Lal Bhalla	Ferozepur	Punjab
5	221000000406	221000000406-1	Force Cable Tv Net Work	Sube Singh	Gurgaon	HARYANA
6	221000000497	221000000497-2	Star City Cable N/W	Sarabjeet Singh	Amritsar	Punjab
7	221000000620	221000000620-1	saini cable	Joginder Singh Saini	Hajipur	Punjab
8	221000000638	221000000638-1	gat body of bbmb cable system at	Anil Gautam	Talwara	Punjab
9	221000000661	221000000661-1	City Cable Opera	Naresh Mittal	Patiala	Punjab
10	221000000679	221000000679-1	varun cable net work	balkishan	Aligarh	Uttar Pradesh
11	221000000836	221000000836-1	Ransi Cable Tv	Lakhvir Singh	Dehlon	Punjab
12	221000000976	221000000976-2	Baghal Cable Network	Mukesh Malhotra	Shimla	HIMACHAL PRADESH
13	221000001149	221000001149-1	a s cable n/w	rajiv singh napalchyal	Dharchula	UTTRANCHAL
14	221000001206	221000001206-1	Goldy Dish Antenna	Nanda Kothari	Banswara	Rajasthan
15	221000001388	221000001388-1	Pawan Cable *Network	Pawan Kumar	New Delhi	DELHI
16	221000001495	221000001495-1	I T I infosat Club	Kaushal Kumar	Raibareli	Uttar Pradesh
17	221000001495	221000001495-2	I T I infosat Club	Anil Kumar Mittal	Raibareli	Uttar Pradesh
18	221000001578	221000001578-2	R & R Cable Network	Rajesh Kumar	Panehkula	HIMACHAL PRADESH
19	221000001669	221000001669-1	Gas Authority Of India Ltd	Sanjeev Kumar	Dibiyapur	Uttar Pradesh
20	221000001867	221000001867-1	Viacom Enterprises	Uday kausah	Goginder Nagar	HIMACHAL PRADESH
21	221000002014	221000002014-1	Shri Shyam Chirawa Citi Cable	Mahesh Kumar Sharma	Chirawa	Rajasthan
22	221000002394	221000002394-1	Gusain Cable Network	Rajesh Singh Gusain	Delhi	DELHI
23	221000002428	221000002428-2	Haldwani Broad Band Service	Mohammad Tarik	Haldwani	UTTRANCHAL
24	221000002477	221000002477-1	Sky waves	Tikky Singh	New Delhi	DELHI
25	221000002493	221000002493-1	Chankya Communication N/w P Ltd	Naresh Jain	Rohtak	HARYANA
26	221000002733	221000002733-1	Chandigarh Network System Pvt Ltd	Sandeep Bansal	Chandigarh	Chandigarh
27	221000002782	221000002782-2	palampur city cable n/w	abhishek sood	Palampur	HIMACHAL PRADESH
28	221000002972	221000002972-1	City Cable Bathinda	Madan Mohan	Bathinda	Punjab
29	221000003137	221000003137-1	SHIVA CABLE NETWORK	YASHWANT	Gopeshwar	UTTRANCHAL
30	221000003350	221000003350-2	shree communication network	Gurinder Jeet Singh	Amritsar	Punjab
Sheet

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A10	1. / Formula is =MOD(ROW(A10),10)=0	Abc

Excel Workbook
	A
1	CustCode
2	221000000976
3	221000001149
4	221000001206
5	221000001388
6	221000001495
7	221000001495
8	221000001578
9	221000001669
10	221000001867
11	221000002014
12	221000002394
13	221000002428
14	221000002477
15	221000002493
16	221000002733
17	221000002782
Sheet

Thanks in Advance

 

[Andrew Poulsom]

Is it:

=INDEX(Sheet1!B$2:B$1924,MATCH($A2,Sheet1!$G$2:$G$1924,0))

in B2 copied down and across?

 

[hardeep.kanwar]

Is it:

=INDEX(Sheet1!B$2:B$1924,MATCH($A2,Sheet1!$G$2:$G$1924,0))

in B2 copied down and across?

Gr8

Works Perfectly