Hello,

My current formula is as follows:=IF(A4="","",VLOOKUP(A4,'Sched of Values'!$A$2:$D$65,2,)) and it works fine, but I am trying to add an extra set of parameters and have been unsuccessful. The formula I am trying is as follows: =IF(B5="*",VLOOKUP(B5,Vendors!A2:B1000,1, IF(A5="","",VLOOKUP(A5,'Sched of Values'!$A$2:$D$65,2,)))). This formula does not allow the original part to work (section that refers to A4) when it is false, the formula should force the VLOOKUP, instead regardless of the entries in A4 or B5 it only returns the word false.

I would appreciate any help.

Thanks,
Mark