Vlookup on columns and rows

[whalay]

Hello,

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

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]ID/CLASS[/TD]
[TD]APPLE[/TD]
[TD]BOY[/TD]
[TD]CAT[/TD]
[TD]DOG[/TD]
[TD]EGG[/TD]
[TD]FAN[/TD]
[TD]GUN[/TD]
[TD]HORN[/TD]
[TD]INK[/TD]
[/TR]
[TR]
[TD]1243[/TD]
[TD]5,600[/TD]
[TD][/TD]
[TD][/TD]
[TD]765[/TD]
[TD][/TD]
[TD][/TD]
[TD]1,123[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1445[/TD]
[TD][/TD]
[TD]2,434[/TD]
[TD]112[/TD]
[TD]445[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]9,400[/TD]
[TD]2,454[/TD]
[/TR]
[TR]
[TD]3243[/TD]
[TD]3,001[/TD]
[TD][/TD]
[TD][/TD]
[TD]223[/TD]
[TD][/TD]
[TD]7,210[/TD]
[TD]222[/TD]
[TD][/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]2112[/TD]
[TD]3,233[/TD]
[TD][/TD]
[TD]211[/TD]
[TD][/TD]
[TD]448[/TD]
[TD][/TD]
[TD]101[/TD]
[TD][/TD]
[TD]2,444[/TD]
[/TR]
[TR]
[TD]6756[/TD]
[TD][/TD]
[TD]9,312[/TD]
[TD]1,121[/TD]
[TD][/TD]
[TD]9,989[/TD]
[TD][/TD]
[TD]1,443[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1111[/TD]
[TD]1,121[/TD]
[TD][/TD]
[TD][/TD]
[TD]9,656[/TD]
[TD][/TD]
[TD]7,121[/TD]
[TD][/TD]
[TD]1,212[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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]

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

 

[whalay]

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

Regards,
Wale