Vlookup Assistance required
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. -- Kind regards Megan |
Vlookup Assistance required
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:A10 0=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 --- "Megan" wrote: 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? |
Vlookup Assistance required
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 --- |
All times are GMT +1. The time now is 01:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com