AUTO INPUT

Copper Contributor

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 price from K9 kr 79

Type in 3035 in D9 it picks the price from K22 kr 83

 

What is the formula to make it like this?

6 Replies

 

@pablo250 

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

 

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

 

@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

@pablo250 

 

Try it with semi-colons ";" in stead of comma's. Your system may have different local settings than mine.

@Riny_van_Eekelen 

 

Like this?

=VLOOKUP(D9;$J$9:$K$56;2;0)

When I press enter it shows #NAME?

 

@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.

@pablo250 

You may use this https://en.excel-translator.de/translator/ tool to translate formula from English on your locale