Forum Discussion

pablo250's avatar
pablo250
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 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?

excel

6 Replies

    • pablo250's avatar
      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's avatar
        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.

Resources