"BenjieLop" wrote:
....
Indeed it is easier to do this but since the OP is new at Excel, I
thought it was more appropriate to enter the individual hard coded
formulas to instill the basic concept of VLOOKUP.

Agreed in principle <g. Albeit it might be a little tough at times for
responders to draw the line where it is felt the core question(s) posed has
been sufficiently dealt with. Cheers.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----