Vlookup query

[St3ph3n31]

Hi guys. Before I start many thanks for any help provided, I know how much time and energy people give to helping others . So many thanks .

Ok I’m quite a movie with Excel, I’m learning as I go so please bare that in mind.

My problem and my question.

I’m building a data base, most of it is complete, however I find myself stuck on one problem in particular.

I hope I explain this correctly so it is understood?

In colum A1 the will be a list of random numbers . These numbers range from 0.25 - 150 . So for example column A, would look like this

A
0.25
1
0.5
10
25
0.25
And so on .

If the number 0.25 to were to appear In A2 i would like it to populate B2 automatically.
If the number 1 was to appear in A2 I would like it to populate C2 automatically

If the number 5 was to appear in cell A2 I would like it to populate cell D2 automatically.

And so on .
Basically the random numbers that appear in column A would need to populate the revelant cells in the right category on the same row as the original number.

For example .

0.25 appears in A501 , so I would like it to automatically populate B501 .

I’ve been searching for an answer, but i’m a bit lost as to how to do it or if it is possibly at all to do ?
The function VLookup seems the closest possibility.
Or does it require a more advanced approach with VBA if it is possibly at all .

Also is there another function that I don’t know of that may solve this issue?

 

[Fluff]

How do you determine which column each number goes in?

 

[St3ph3n31]

Hi Fluff , thank you .
Each column B C D E F G has a header
B being 0-1 C being 1-5 C being 5-10 and so on .
What I would like is for the number the appears in A2 regardless of what it is auto populates the right column .
And the same for the random numbers that follow in column A .

They numbers have to be on the same row but in the right column for that number.

This is where I’m stuck, I just don’t have a clue how to make it happen ?

 

[Fluff]

Something like

Excel 2013/2016
	A	B	C	D	E
1		0-1	1-5	5-10	10-50
2	0.25	0.25
3	1		1
4	0.5	0.5
5	10				10
6	25				25
7	0.25	0.25
Color

Cell Formulas
Range	Formula
B2	=IF(AND($A2>=LEFT(B$1,FIND("-",B$1)-1)*1,$A2B$1,LEN(B$1)-FIND("-",B$1))*1),$A2,"")

 

[St3ph3n31]

Yes exactly like that . Wow thank you .
How would Input the formula ?

 

[Fluff]

Just copy & paste it into your workbook, changing the ranges as required.

 

[St3ph3n31]

Awesome thank you Fluff I’ll love you forever if this works. Could you just show me the formula for column E so I have a comparison regarding ranges to change please . I’m not at the point yet to under standing complex code .

 

[Fluff]

If you put the formula into B2, then drag down & across, it should work without any changes

 

[St3ph3n31]

Even better , thank you, I shall try it as soon as I get home from work . Thank you so much for your time and expertise

 

[Fluff]

You're welcome & thanks for the feedback