Vlookup on columns and rows

[whalay]

Hello,

I need to do a Vlookup using criteria from the columns and rows. For example:

ID/CLASS	APPLE	BOY	CAT	DOG	EGG	FAN	GUN	HORN	INK
1243	5,600			765			1,123
1445		2,434	112	445				9,400	2,454
3243	3,001			223		7,210	222		30
2112	3,233		211		448		101		2,444
6756		9,312	1,121		9,989		1,443
1111	1,121			9,656		7,121		1,212

<tbody>
</tbody>

In another sheet, I have the ID and class but not arranged in this order. The data is large and would be tasking to go through manually. The ID/Class are unique identifiers.

How do I go about it? Your prompt response would be appreciated

 

[CodeNinja]

ID/CLASS	APPLE	BOY	CAT	DOG	EGG	FAN	GUN	HORN	INK
1243	5,600			765			1,123
1445		2,434	112	445				9,400	2,454
3243	3,001			223		7,210	222		30
2112	3,233		211		448		101		2,444
6756		9,312	1,121		9,989		1,443
1111	1,121			9,656		7,121		1,212
ID	CLASS	RESULT	FORMULA
1445	DOG	445	=INDEX($B$2:$J$7,MATCH(A11,A2:A7,0),MATCH($B$11,$B$1:$J$1))

<tbody>
</tbody>

 

[whalay]

Thanks for the prompt response. Would revert if I need more assistance.

Regards,
Wale