Multiple VLOOKUP??

I have a matrix where at times some of cells get a value. I need those values for other calculations but VLOOKUP only takes the first of them. Is there any other way to get to an array which shows all the values I need? I have scanned the web and there are some privately developed functions but it looks they dont work, or maybe I am doing something wrong. Any idea out there??!!

Many thanks

BC

Hi BC,
I think I had a similar issue a little while a go.
My problem was that I needed to look for a year and for a month.
I concatenated both values in my search string:
+A1&B1
where A1 holds the year and B1 the month. The string it created would
look funny, but if you create a similar string in your lookup table
your might be solved.

Good luck
Peter

cheers Peter