I have included a simple spreadsheet with 4 named arrays Products_A to Products_D, you will see the Cost in cells B11 to B14 alter as the cell A1 is changed from A to B to C to D. I want to edit the formulas in B11 to B14 to include a variable in place of the array name, in an effort to shorten the fomula, as there are many more product ranges and prices to be added. Presently the formula is as follows:
I want to change the formula to =IF($A$1="A",VLOOKUP(A11,D
etc etc where D3 changes when the value of D1 alters, but this returns #N/A as indicated in D11. Sorry if it's not too clear but I've tried to explain it as best I can.