Nov 27 2019 09:32 AM
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?
Nov 27 2019 11:54 AM
Nov 28 2019 08:05 AM
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
Nov 28 2019 08:24 AM
Try it with semi-colons ";" in stead of comma's. Your system may have different local settings than mine.
Nov 28 2019 08:33 AM
Nov 28 2019 09:17 AM - edited Nov 28 2019 09:18 AM
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.
Nov 28 2019 12:15 PM
You may use this https://en.excel-translator.de/translator/ tool to translate formula from English on your locale