I am new to this forum and a novice with Excel especially with respect to creating fomulas.

Help !!

I have created a VLOOKUP table that has a value grid of 7 rows x 5 columns (apartment codes x different rates depending on length of stay). Therefore depending on the apartment code the guest wants and their length of stay there are 35 possible results.

Using this forum, I managed (somehow) to put together a few concatenated IF statements to point to the correct cell in the VLOOKUP table depending on apartment code and length of stay. I now realise that I will have to do 35 concatenated IF statements and my head is beginning to explode just doing two !

Is there a better way ? I know thereis a limitof 7nested IF statements but is there a limit to thenumber of concatenated IF statements (if that is a different thing) ?

Some examples of my bodged (but working) code is :-

=IF((AND(B310,B31<8,F21="KOC05")),VLOOKUP(F21,Pri ces!A3:C10,3,FALSE),IF((AND(B310,B31<8,F21="KOC03 ")),VLOOKUP(F21,Prices!A3:C10,3,FALSE),"Invali d Input"))

p.s1
length of stays are daily, weekly, monthly, 3 monthly and 6 monthly.
ps2
administrator will just input apartment code and length of stay to automatliccly pass rate to an invoice.