i need help with a task

[Markidjani]

I need when i enter the left numbers (do 14, 14.1-14.5..) let's say in column A to get in the next column B numbers from the next column(13.5, 13.4, 13.3)

[Glenn Kennedy]

Please delete the photograph and replace it with an Excel file. Don't clutter the place up!!!

[Pete_UK]

Click on the File button and then on Excel Options (at the bottom of the pane), Click on Advanced, and you can see the first option allows you to choose in which direction the cursor should move when you press Enter - change this to Right, then click OK.

You will need to use the mouse to move the cursor to the next row.

Hope this helps.

Pete

[Markidjani]

Thanks for the help Pete. Actually i need a formula how to get, when i enter those number on the left, numbers on the right

[Glenn Kennedy]

At least the football photograph has gone...

[Pete_UK]

Assuming you have already entered the data from the table into Excel, say in columns A to D of Sheet1 (where column B is Vlaga %), then if you use A1 of Sheet2 to enter a value like 14.1-14.5 you can use this formula in B1 to return the corresponding value from column C:

=IFERROR(VLOOKUP(A1,Sheet1!$B:$C,2,0),"")

Hope this helps.

Pete

EDIT: you might need to use semicolons ( ; ) instead of commas ( , ) in the formula.

[Special-K]

Shouldn't the subject of this thread be changed too according to Rule 1 (Be nice if someone read them for a change) ?

https://www.excelforum.com/forum-rul...rum-rules.html

[AliGW]

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.