Formula to generate a set number in each cell

[emilyp9]

Good morning,

I am working on a sheet and I am rusty on my Excel formulas. I have a column that needs to auto fill based on certain criteria. If a number typed in column B is 130,131,132,133,134,135 then column C needs to equal 25.8, if the number typed in column B is 136,137,138,139 then column C needs to equal 53.4, If B is 147 then C is 31.95

It continues on with specifics built off a tab on the sheet....
Any help is appreciated.

 

[Fluff]

Hi & welcome to MrExcel
If you have a list of the values & what you need you can use something like

Book1
	B	C	D	L	M
1				List	Return
2	135	25.8		130	25.8
3				136	53.4
4				140	36.9
5				147	31.95
Master

Cell Formulas
Range	Formula
C2	=VLOOKUP(B2,L2:M5,2)

 

[emilyp9]

Daily the number 130, 131,132... ect would be manually typed and not in the same place. Could I send you what I am working on?

 

[Fluff]

You can upload to file to somewhere like OneDrive, DropBox, GoogleDrive mark for sharing & then post the link to the thread.

 

[emilyp9]

https://drive.google.com/file/d/1gUTD2Y6yWc6OAFwhPSFkVxq6nqht7l2c/view?usp=sharing

I'm lost..

The "Help Route" column is going to be typed in daily but will be different daily. The tabs Mon, Tues, .... have the tables that I need to reference.

I'm trying to get O3 to calculate E3+N3 but its time and I can't figure it out...

 

[Fluff]

In G3 copied down & across to col H
=IFERROR(VLOOKUP($F3,INDIRECT(TEXT($D$1,"ddd")&"!C2:E48"),COLUMNS($A$1:A$1),0),"")