Automatically filling a cell with a value from a table based on the value of a cell next to the destination cell

[Leonard010193]

Afternoon,

I have table made up of the following values

Column A	Column B
2.5	1
4	2
6	3
10	4

I want to be able automatically take the values in column B based on the value in column A.

So if I enter the value of 2.5 in cell C5 for example, I want cell C6 to automatically fill the value in column B next to the value 2.5.

So C6 should show the value 1 if cell C5 = 2.5

Any help would be amazing.

Thank you.

 

[Fluff]

How about

=INDEX(B2:B5,MATCH(C5,A2:A5,0))

 

[Z51]

Standard VLOOKUP formula here...

=VLOOKUP(C5,$A:$B,2,0)

 

[Leonard010193]

How about

=INDEX(B2:B5,MATCH(C5,A2:A5,0))

This is perfect, thank you.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Leonard010193]

Glad we could help & thanks for the feedback.

Hello,

is it possible to have two index statements to fill a cell?

In this instance, I need to be able to enter numbers 1 to 5 in column B cells which populates column C with the cable type from the controls cable table (2nd screenshot).

The cable type in column C then needs to select the appropriate price base on the cable type and number of cores. I've got them working individually but ideally I need simultaneous, so when I change the cable type in column B and the cores number in column D it applies the appropriate price in column E.

Hope this make sense.

 

[Fluff]

You will need put the type into each row on the controls cable table.