| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I find a specific value in a random column of numbers
I have two columns of numbers, A1 = volume & B1 = an associated time
interval. I need to look down column A and find the first time a specific value appears and then capture its corresponding value in column B to use in another formula. Ex: I need to find 237.50 in A and use the corresponding 117.8. Thanks Col A Col B 220.70 5.60 203.90 12.20 187.10 18.80 170.30 25.40 153.50 32.00 136.70 38.60 119.90 45.20 103.10 51.80 86.30 58.40 69.50 65.00 93.25 71.60 117.00 78.20 140.75 84.80 164.50 91.40 188.25 98.00 212.00 104.60 235.75 111.20 237.50 117.80 237.50 124.40 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random numbers of 1-9 using only 4 numbers in each column | Excel Worksheet Functions | |||
| find a specific value in a column and write another column | Excel Discussion (Misc queries) | |||
| find formula that will look up a value in a specific column and . | New Users to Excel | |||
| find numbers in a range that add to a specific value | Excel Discussion (Misc queries) | |||
| How do I split a column having numbers and text in a random order | Excel Worksheet Functions | |||
Threaded Mode
