Vlookup complex workbook

Hi everyone!

I have a complex workbook I need assistance on.

I have attached the workbook.

On the tab that reads custom input tab, column A:S are the input data fields. Column T:AA are the results.

I need the results (Column T:AA) to do a contingent if/then vlookup AND yield a blank if no information is present in the input data.

In addition to this the contingent is that the results need to do one of 30 Vlookups based on the input in column C

So for example Row 2 should yield the following

1). Because column C reads 1, it should Vlookup rate chart page column A4:C104. If it read 2 it should Vlookup rate chart page column C4:D104. If it reads 3 it should Vlookup rate chart page column E4:F104, etc, etc, etc for 30 different rate charts.

2) Column T should reference Column E and do a Vlookup (in the correct array) and match the number to the appropriate rate (in this case 471.46)

3). Column U:AA should reference their respective reference numbers (G, I, K, M, O, Q, S) and do a vlookup to the same array as above however I also need it to yield a blank IF and only IF the cell is blank. I cannot have it yield a 0 because there is a 0 in the arrays.


Right now I can do a simple vLookup. I do not know how to make that Vlookup yield a blank if the refernce field is blank.

I am usung this formula =IFERROR(VLOOKUP(G2,'Rate chart'!A4:B104,2,0),"")

I also do not know how to make the Vlookup conditional on the number in column C.

Can this even be done? I know it's compley but I have a lot of variables to work with.