Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If( AND( with VLOOKUP....
'=IF(AND(B2:B5=A1,C2:C5="WEEK1"),VLOOKUP(C10,$B$2: $D$5,3,FALSE),"") - this
formula gives me a #VALUE error. A1 = 10 A2 = 11 col B col C Col D Col E Col E STR_NBR WEEK1 TTOH RGOH MEMO 10 WEEK1 5363 4407 234 11 WEEK1 7424 5561 605 10 WEEK2 3160 2543 352 11 WEEK2 2655 1995 246 10 WEEK3 3160 2543 352 11 WEEK3 2655 1995 246 I will need to look up data from collumns D - E for 800 stores for 15 weeks. any suggestions? thank you in advance. jane |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |