Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FORMULA ASSISTANCE REQUIRED | Excel Discussion (Misc queries) | |||
Conditional Formatting - further assistance required | Excel Worksheet Functions | |||
Assistance required | Excel Discussion (Misc queries) | |||
Formula Assistance Required | Excel Worksheet Functions | |||
Formula assistance required!!! | Excel Discussion (Misc queries) |