jane wrote:
'=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




Looks like this should be an array formula. Did you use CTRL+SHIFT+ENTER?