Using vlookup to check for 4 valid conditions


Posted by Dominic on September 04, 2001 1:53 AM

I have a table where I have concatenated 4 columns into one, so as to do a vlookup for a value in another table. But I would like to know is there a vlookup where you can search for a range in a range. I have tried this formula and it does not work
=Vlookup(A22:C22;'Plan pro Monat'!A22:AG90;8)



Posted by Aladin Akyurek on September 04, 2001 11:26 AM

Dominic,

I have the impression that your question might need the same kind of answer as the one discussed at

28849.html

If not so, would you elaborate?

Aladin

=============