I am trying to accomplish something and I think that HLOOKUP and/or VLOOKUP is what I need but I have not been able to get it right. I have large grid in Sheet1: (example)
 	AP	AO	AN	AM
A300	160	150	140	130
A301	160	150	140	130
A302	170	180	190	200
A303	170	180	190	200
A304	480	470	460	450
In a seperate worksheet (sheet2) I have a listing of items where the first four characters would match the items in column 1 (A301) and the 5th and 6th characters would match up with the items in row 1(AN), and need a formula that could use that data to populate the number pulled from that combo. So that if column 1 listed an item as A304AN03, that the formula in column 2 would reflect 460 as the value. Is that possible? Am I making any sense?

Thanks in advance!
Ajax