I have read into my problem more and looked up Vlookup - but cannot seem to get the correct table created, formula, or the results I need:
Column I Column T (price)
has the following info: (memory size)
8GB (1x8GB) 135
16GB (2x8GB) 265
32GB (4x8GB) 524
48GB (6x8GB) 797
64GB (8x8GB 998
96GB (12x8GB) 1497
128GB (12x8GB) 1997
144GB (16x8GB) 2218
196GB (18x8GB) 2948
256GB (32x8GB) 3887
Help with the formula would be much appreciated..
Column I Column T (price)
has the following info: (memory size)
8GB (1x8GB) 135
16GB (2x8GB) 265
32GB (4x8GB) 524
48GB (6x8GB) 797
64GB (8x8GB 998
96GB (12x8GB) 1497
128GB (12x8GB) 1997
144GB (16x8GB) 2218
196GB (18x8GB) 2948
256GB (32x8GB) 3887
Help with the formula would be much appreciated..