You need a basic VLOOKUP formula. In your example image, in cell `G11`

enter the formula `=VLOOKUP(F11,A:C,2,FALSE)`

. In cell `H11`

you would need `=VLOOKUP(F11,A:C,3,FALSE)`

`F11`

contains your lookup value, `A:C`

is the cell range for your table and the value following that is the `col_index`

value (the column of the cell range) to be returned. (If `A:C`

was `B:D`

then `col_index`

of `2`

would return the value in column `C`

).

The last bit which is the `range_lookup`

value controls whether value needs to match exactly or not.

Set `range_lookup`

to `FALSE`

to require an exact match and `TRUE`

to allow a non-exact match.

If `range_lookup`

is `TRUE`

(the default setting which is also used if `range_lookup`

is not set) you need to make sure that lookup values in the first row of the table are sorted in ascending order. Otherwise, VLOOKUP may return an incorrect or unexpected value.

If `range_lookup`

is `FALSE`

(require exact match), values in the first column of table do not need to be sorted.

You have already got your drop down boxes sorted but for completeness, to get drop down lists in column `F`

,

- Select column
`F`

. (You can position the drop-down list in most any cell or even multiple cells.)
- Choose
`Validation`

from the Data menu.
- Choose
`List`

from the `Allow option`

's drop-down list.
- Click the
`Source`

control and simply enter the reference `=$A:$A`

.
- Make sure the
`In-Cell Dropdown`

option is checked.
- Click
`OK`

.

`=VLOOKUP`

function. The code would be (on G12) something like`=VLOOKUP(F12, A1:C100,2)`

. It basically means look up code in F12 to match the table of A1:C100, and then if a match found, return content in column index 2 (which is Column B) - you can use the same code for H, and return index 3. I don't know how to make the drop down menu... so if someone can expand on this? – Darius Nov 14 '16 at 5:07