Enter a number and this generates another from a pre-set list

[andyking40]

Hi all,

I'm trying to create a really simple sheet but it still beats me

In a nutshell I have a column where I'd like to enter a number (0.5 - 128) and by doing so, this it would generate another number from a pre-set list in another column. E.g. I enter "16" (Bet) and in the next column it shows "31.5" (Spend).

I feel a little dumb to be honest as I don't think it can be that hard, but have tried many times and searched the 'help' to no avail.

Hence I'm here, begging assistance.

[NBVC]

Try:

=LOOKUP(B3,$J$2:$K$10)

where B3 contains input

[FDibbins]

not sure where you want to put this, but try using...
=VLOOKUP(B3,$J$2:$K$10,2,FALSE)

[andyking40]

Wow, thank you very much for such a fast response.

Sadly it didn't work, I receive a "Circular Reference Warning" and if I enter a number in B3 (e.g. 16) it simply subtracts that number in the "Spend" column next to it as opposed to "31.5" as hoped.

I hope I've explained it correctly and I am grateful for any help.

[andyking40]

Gosh, you guys are amazing!

Never come across a site like this for helpfulness and speed... many many thanks both.

FDibbins code worked perfectly and an Excel novice has learned something new.

I'll tick the reputation boxes and say thank you once again.

[NBVC]

You don't put the formula in B3... B3 is the reference for your input.. the formula goes in another cell to pull the Spend from the table...

[andyking40]

Edit... BOTH codes worked perfectly, I did enter it in the wrong place! Thank you so much.

[FDibbins]

glad to help and thanks for the star