Issue with formula

[richard1234567891011]

Hello guys,
I am trying to set a formula. The formula that I need Is something: If F5 is one stuff here, G5=to the corresponding stuff in the table below.
F5 is the cell with multiple choice
the formula has to be insert in G5, were actually there is 160.
Thank you.

 

[oldbrewer]

It is not clear imho, what you want....

 

[AlanY]

a simple lookup should do, try

=VLOOKUP(F5,E14:F21,2,0)

in G5

 

[Dryver14]

in G5 =vlookup(F5,E14:F21,2,0)

 

[richard1234567891011]

I need a formula in G5 (where there is 160) that it follows the letters in the next cell using the table below.
example. If you select C/1 I want G5=55, If you select C/2 C/6 C/7 I want G5=160, If you select D/5 I want G5=80 and so on.

 

[richard1234567891011]

It works. Thank you a lot. to both.

 

[oldbrewer]

													A/1	100
													A/10	80
													A/11	100
													A/2	100
													A/3	100
													A/4	100
													A/5	100
													A/6	100
				A/4	100								A/7	100
				B/4	140								A/8	100
				C/1	55								A/9	100
				C/2	160								B/1	140
				C/3	140								B/2	140
				D/3	65								B/3	140
				D/8	65								B/4	140
													B/5	140
													B/6	140
													B/7	140
													B/8	140
													C/1	55
				using a simple lookup table							C/2	160
													C/3	140
				is this what you want ?							C/4	140
													C/5	140
													C/6	160
													C/7	160
													D/1	65
													D/10	65
													D/2	65
													D/3	65
													D/4	65
													D/5	80
													D/6	65
													D/7	65
													D/8	65
													D/9	65

<colgroup><col width="64" span="16" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[AlanY]

It works. Thank you a lot. to both.

you're welcome