Match values in two columns and return value using vlookup from third column in Excel -
i have worksheet (called final) similar data below: b c year month births 1880 1 530 1880 2 456 1880 3 234 1890 1 163 1890 2 123 1890 3 125 second spreadsheet: b c d year month births 1880 1 1890 2 1890 3 i wish mach value column in sheet 2 e.g. 1880 sheet 2, in sheet 1 column return value in d when meets specific month criteria e.g. 1880(a) , 1(b) return 530 in column d this formula wrote not give me (gives na) =if(if(a2=final!b12,true,false),true,vlookup(final!a2,final!b12:c3532,2,false)) to me logic is, if a2=b2 true outer if gets true , if true vlookup , return value in second column else false) doesn't work you need put logic in lookup. =index(final!$c$1:$c$500(match(1,if(a2=final!$a$1:$a$500,if(b2=final!$b$1:$b$500,1,0),0),0)) this array formula. needs confirmed ctrl-shift-en...