Vlookup Assistance required

[Megan]

I need to bring back the data from column F, R I and W but they have two look
up values in A and G.

I only want the info transfering if A and G on sheet 1 match A and G on the
new data sheet.

What formula do I need?

Assistance much appreciated.

 

[Max]

One way to bring over Sheet2's col F
In Sheet1,
you could use, normal ENTER
=INDEX(Sheet2!F2:F100,MATCH(1,INDEX((Sheet2!A2:A100=A2)*(Sheet2!G2:G200=G2),),0))

Just change this part: Sheet2!F2:F100 in the expression
for the other cols in Sheet2 to be extracted, ie cols R, I, W
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik

 

[Max]

Typo in the earlier expression, sorry:

Sheet2!G2:G200 should read as: Sheet2!G2:G100

(all 3 ranges should be identical size)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---