I am trying to create a product calculator for a website. Hopefully will use spreadsheetconverter to make this into a web form.
However it does not support the indirect function.
How can I reference a different worksheet based on the contents of a cell without the indirect function.
C1 contains "RED, BLUE, GREEN"
My formula that works with indirect is
Thanks for any suggestions
However it does not support the indirect function.
How can I reference a different worksheet based on the contents of a cell without the indirect function.
C1 contains "RED, BLUE, GREEN"
My formula that works with indirect is
Code:
=IFERROR(VLOOKUP(ROUNDUP((C3-(2*C4))*0.8,0),INDIRECT(C2&"!A1:E50"),2,2),"Out Of Range - Please contact Sales")Thanks for any suggestions
