MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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


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


If not so, would you elaborate?