Posted by Mike Petkash on August 15, 2001 7:08 AM
Any help on this topic would be very appreciated. I have to create a function that would first look to one variable, then to another and return an appropriate value. I cannot use nested if-then statements because I have ten (10) variables for the first item and about 100 for the second. The first variable is an item that is called S1 - S10. The second variable is a run rate for each S*. Thus, I need a formula that will first pull the correct code, then look for the appropriate run rate, and return the correct price for the run rate.
My formula at the moment looks like:
=IF(B117=0,0,(D117*(C117*(VLOOKUP(B117,'Press Run'!A1:D100,(VLOOKUP((D117*1000),'Press Run'!A1:D100,4)))))))
In changing certain items, I either have a "#N/A" returned or "#REF."
Thanks in advance for any help you can give.