vlookup sum two cells

[asyamonique]

Hello,
Is it possible to add into below formula sum function like i need to get total of 10th and 12th cell values.
Thanks

=IFERROR(VLOOKUP(A2,master!$CF$3:$DG$500, 10, FALSE),"")

 

[Misca]

Just add another VLOOKUP and sum the results.

You might want to change the IFERROR result to 0 for both you're trying to sum. After this it's up to you what you want to show if the sum returns a zero (which doesn't necessary mean both VLOOKUPs returned an error).

 

[asyamonique]

Yes calculated but if there is no values it shows as.

#VALUE!

 

[mohadin]

=IFERROR(VLOOKUP(A2,master!$CF$3:$DG$500, 10, FALSE)+VLOOKUP(A2,master!$CF$3:$DG$500, 12, FALSE),"")

 

[jasonb75]

If you're using anything other than office 365 then you might need to array confirm this.

=IFERROR(SUM(VLOOKUP(A2,master!$CF$3:$DG$500,{10,12}, FALSE)),"")