Vlookup for multiple column index number and Multiple criteria

[Marshall008]

Hello My people.

Thanks for always assisting me, I'm here again. Find the attached excel sheet. I want to calculate dog nutrition based on two variables which are Age and Weight. I have the chart already, i just want my excel to look for the exact value for the age and weight on the food chart and display the result. I have weight in kg or Lbs. you can use anyone out of it.

Waiting for your kind response. thanks

[Bo_Ry]

Please try at F7

=INDEX(Sheet1!$C$4:$G$14,MATCH(C7,Sheet1!$A$4:$A$14,),MATCH(D7,Sheet1!$C$3:$G$3,))&""

[protonLeah]

Age =Sheet1!$N$5:$N$9
Units =Sheet1!$A$3:$B$3
Weights =Sheet1!$A$4:$B$14

data val for B7: =units
data val for C7: =INDEX(Weights,0,MATCH($B$7,Units,0))
Data val for D7: =Age
result:

Please Login or Register  to view this content.

[Marshall008]

Age =Sheet1!$N$5:$N$9
Units =Sheet1!$A$3:$B$3
Weights =Sheet1!$A$4:$B$14

data val for B7: =units
data val for C7: =INDEX(Weights,0,MATCH($B$7,Units,0))
Data val for D7: =Age
result:

Please Login or Register  to view this content.

Thanks very much, You did a great job for me. Please, the image on the dashboard is for what, because I try to edit it, it was not editable.

[Marshall008]

Please try at F7

=INDEX(Sheet1!$C$4:$G$14,MATCH(C7,Sheet1!$A$4:$A$14,),MATCH(D7,Sheet1!$C$3:$G$3,))&""

Thanks for your, Response, I really appreciate it.

[protonLeah]

The picture should be deleted. I just used it while working...

[Marshall008]

Thanks God Bless you.

[Marshall008]

The picture should be deleted. I just used it while working...

Hello ProtonLeah,

Please, I tried to, put import it into google spreadsheet, the drop-down button for the weight, is not coming up as a result of not listed for data validation. How can I correct this on that spreadsheet

[protonLeah]

I'm sorry but I don't work with google docs. Maybe this should be a new question for the forum...