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)