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

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
- Riny_van_Eekelen
  Platinum Contributor
  Nov 28, 2019
  pablo250
  Guess you are not on an English version of excel. Norwegian by any chance? Google tells me it should be FINN.RAD in stead of VLOOKUP. And try commas again if it doesn't work with semi-colons.