Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
search from range in column 1 and print from corresponding values
column 1 column 2
0-100 2 101-200 4 201-300 6 301-400 8 401-500 10 I need a formula that would look whether a no. entered in a cell falls in which range in column 1 and print the corresponding value in column 2. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
search from range in column 1 and print from corresponding values
Hi,
If you change the first column to read 0 2 101 4 201 6 301 8 401 10 Then you can use =VLOOKUP(H1,A1:B5,2,TRUE) Where H1 contains the number you want to look up and your modified table is in the range A1:B5. -- Thanks, Shane Devenshire "manu" wrote: column 1 column 2 0-100 2 101-200 4 201-300 6 301-400 8 401-500 10 I need a formula that would look whether a no. entered in a cell falls in which range in column 1 and print the corresponding value in column 2. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question regarding how to search a column and print a row(s) | Links and Linking in Excel | |||
Question regarding how to search a column and print a row(s) | Excel Discussion (Misc queries) | |||
Question regarding how to search a column and print a row(s) | Excel Worksheet Functions | |||
Question regarding how to search a column and print a row(s) | Excel Discussion (Misc queries) | |||
Question regarding how to search a column and print a row(s) | Excel Worksheet Functions |