Hi Alan
it was too late for this post I think. What I wanted to say was:
I woulds use multiple VLOOKUPs. One for each column, each refering to
the same search criteria.
and after this just a refernce to get the basic understanding of
vLOOKUP :-)

--
Regards
Frank Kabel
Frankfurt, Germany


Alan Beban wrote:
Frank Kabel wrote:
Hi
use VLOOKUP (multiple) for this. See:
http://www.mvps.org/dmcritchie/excel/vlookup.htm

I don't find any section or heading VLOOKUP (multiple)

Alan Beban