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

 

Resources