Solved How do I create a formula which includes all of the below?

September 12, 2016 at 19:28:09
Specs: Windows 64
 Please help!.....is it possible to create a formula which automatically puts the number in column B which corresponds to the values in column A??For example; if i entered 1.1, which is between 1 but less than 2 it would say 4 (see column B). Or if I put 3 it would put the number 7 (see column B)Column A Column B 1 > 2 42 > 3 63 > 4 74 > 5 85 > 6 106 > 7 117 > 8 138 > 9 149 > 10 1610+ 12message edited by cass01234

See More: How do I create a formula which includes all of the below?

#1
September 12, 2016 at 19:29:42
 sorry those numbers from column B have moved acrossColumn B should read4678101113141612

#2
September 12, 2016 at 20:48:28
 First, a posting tip:Please click on the blue line at the end of this post and read the instructions on how to format example data so that it is easier for us to read. Don't forget to use Column letters and Row numbers as shown in the example. Thanks! I think VLOOKUP should work for you.Start with this table in C1:D10:``` C D 1 1 4 2 2 6 3 3 7 4 4 8 5 5 10 6 6 11 7 7 13 8 8 14 9 9 16 10 10 12 ```Now enter this in B1 and try some values in A1=VLOOKUP(A1,\$C\$1:\$D\$10,2,1)The key to this formula is the range_lookup argument of "1" (TRUE) when means that VLOOKUP will look for an approximate match in Column C.