Jase,

See www.cpearson.com/excel/lookups.htm for information about left
lookups.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Jase" wrote in message
...
Hi All

I remember in the not to distant past someone posting a
listing on how to get excel to do a left lookup using
stuff like offsets to get the result, however I can not
seem to find the post.

Would someone beable to refresh my memory please

Thanks
Jase