Look Up values from a special format table

[Ecel Dumbo]

Hello Dear Excel friends,


Could you please kindly refer the attached work sheet and advise a formula to look values from a special constructed table.

It would be great to get the values without making changes to the original structure of the table.


http://speedy.sh/DXA8y/Look-up-formula-from-a-special-table.xls


Thankls heaps


Excel Dumbo

 

[NARAYANK991]

Hi ,


Can you check your file here ?


http://speedy.sh/kFMwD/Look-up-formula-from-a-special-table.xls


I have not used your formula as it is ; also I have used a helper column. See if it is acceptable.


Narayan

 

[Ecel Dumbo]

hello narayan....served the purpose...works like magic...heaps of thanks a lot for your time