Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup formula
Hi, I have the following 2 formulae and i have been desperately trying to
make them work but the dont! I am looking up the value of column D in 1 worksheet to look across 10 different sheets (which are all named) and then return the results as "1,0" when done into another sheet. So i am just looking up names from column D of sheet"names" and then looking across 10 sheets, again in the same column - D. These are the formulae i have tried. the 1st works on the sheets being called sheets 1,2 etc and not being renamed and the 2nd formula allows you to name the sheets then refer to them seperatly. i would like to use the 2nd as i all my sheets are named. =VLOOKUP(B1,INDIRECT("sheet"&MATCH(TRUE,COUNTIF(IN DIRECT("sheet"&ROW(INDIRECT("1:10"))&"!d2:d100"),B 1)0,0)&"!d2:d100"),1,0) =VLOOKUP(B2,INDIRECT(""&INDEX($A$1:$A$3,MATCH(TRUE ,COUNTIF(INDIRECT(""&$A$1:$A$3&"!d2:d100"),B1)0,0 ))&"!d2:d100"),1,0) I either get the response N/A or VALUE. i dont know if i have got all the referenes correct, maybe thats why its not working. maybe the "d2:d100" is incorrect as i repeat it in the formula, but this is the range where the lookup should look in. I hope im making sense. Thanks for your help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 VLOOKUP formula or other formula | Excel Discussion (Misc queries) | |||
Vlookup using a formula possible? | Excel Worksheet Functions | |||
VLookup Formula | Excel Discussion (Misc queries) | |||
vlookup formula | Excel Worksheet Functions | |||
how to use vlookup formula | Excel Worksheet Functions |