Expanded if? or Index Match

[IGinc]

Column I Column T (price)

has the following info: (memory size)

Column T has price, some correct info, hoping I could apply a formula, this is what would need the formula to match up. Thanks.

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

Thanks for any tips or leads would be real helpful, for a client. I'm open to any solution that would work, I think it should be fairly simple.

 

[Marcelo Branco]

Maybe this can help

http://www.contextures.com/xlfunctions02.html

M.

 

[IGinc]

Maybe this can help

http://www.contextures.com/xlfunctions02.html

M.

I'm not familiar with Vlookup, I had looked up about Vlookup, can someone help me write a formula?

 

[Aladin Akyurek]

Care to re-word the question you have?

 

[T. Valko]

Column I Column T (price)

has the following info: (memory size)

Column T has price, some correct info, hoping I could apply a formula, this is what would need the formula to match up. Thanks.

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

Thanks for any tips or leads would be real helpful, for a client. I'm open to any solution that would work, I think it should be fairly simple.

Try this...

Book1
	A	B	C	D	E	F
1	Capacity	_	Price	_	Lookup	Price
2	8GB	(1x8GB)	135	_	48GB	797
3	16GB	(2x8GB)	265	_	_	_
4	32GB	(4x8GB)	524	_	_	_
5	48GB	(6x8GB)	797	_	_	_
6	64GB	(8x8GB	998	_	_	_
7	96GB	(12x8GB)	1497	_	_	_
8	128GB	(12x8GB)	1997	_	_	_
9	144GB	(16x8GB)	2218	_	_	_
10	196GB	(18x8GB)	2948	_	_	_
11	256GB	(32x8GB)	3887	_	_	_
Sheet1

This formula entered in F2:

=VLOOKUP(E2,A2:C11,3,0)

 

[IGinc]

This formula works fine, however it is not the solution I am seeking.

The only data I have in the sheet is Column I, is there a way to rearrange the table and or formula so that I can paste column I, into a column, and have the results I would like the formula/table to generate the prices. This way I can copy and paste them into Column T.

Hope this is clearer of what I need.

 

[T. Valko]

This formula works fine, however it is not the solution I am seeking.

The only data I have in the sheet is Column I, is there a way to rearrange the table and or formula so that I can paste column I, into a column, and have the results I would like the formula/table to generate the prices. This way I can copy and paste them into Column T.

Hope this is clearer of what I need.

Not sure I understand.

Do you mean that this:

8GB (1x8GB) 135

Is all in one cell?

 

[Aladin Akyurek]

...The only data I have in the sheet is Column I, is there a way to rearrange the table and or formula so that I can paste column I, into a column, and have the results I would like the formula/table to generate the prices. This way I can copy and paste them into Column T.

Hope this is clearer of what I need.

Looks like Data | Text to Columns would yield the lay-out you describe.

 

[IGinc]

no Column I is just memory info there are prices, that can be entered into a column... any ideas?

 

[T. Valko]

no Column I is just memory info there are prices, that can be entered into a column... any ideas?

Sorry, if the lookup I suggested isn't what you want then I don't understand what you want.