Forum Discussion

Copper Contributor

Nov 27, 2019

AUTO INPUT

When I type in a number in D9 to D28 it should pick the number from K9 to K30 It needs to pick the right number in collum K9 K30 when I type in D9-D28. eksample: Type in 3004 in D9 it picks the pr...

excel

Riny_van_Eekelen

Platinum Contributor

Nov 27, 2019

pablo250

In E9, type the following formula and copy it down.

=VLOOKUP(D9,$J$9:$K$30,2,0)

pablo250

Copper Contributor

Nov 28, 2019

Riny_van_Eekelen

Hi Riny,

Thank you for your respond.

When I ad: =VLOOKUP(D9,$J$9:$K$30,2,0) in E9 I get message from excel that there is a problem with the formula. Please see the attached file..

Thank you

Paal

Riny_van_Eekelen
Platinum Contributor
Nov 28, 2019
pablo250

Try it with semi-colons ";" in stead of comma's. Your system may have different local settings than mine.
- pablo250
  Copper Contributor
  Nov 28, 2019
  Riny_van_Eekelen
  
  Like this?
  =VLOOKUP(D9;$J$9:$K$56;2;0)
  When I press enter it shows #NAME?
  - SergeiBaklan
    Diamond Contributor
    Nov 28, 2019
    pablo250
    
    You may use this https://en.excel-translator.de/translator/ tool to translate formula from English on your locale