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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I find a specific value in a random column of numbers
You can use VLOOKUP but your data will need to be in ascending order by the
lookup column. =VLOOKUP("237.50",A1:B19,2,0) HTH, Paul "yazmaz" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I find a specific value in a random column of numbers
=VLOOKUP(237.5,A1:B19,2,0) or more generally =VLOOKUP(C1,$A$1:$B$100,2,0) where C1=237.5 HTH "yazmaz" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I find a specific value in a random column of numbers
Thanks to all that responded but I can not put column A in ascending order
because column A represents the emptying and then filling of a tank (volume) and Coulmn B represents the time in minutes to complete the process. The tank volume decreases to a certain point and then starts to increase until it hits 237.50 and then every volume after that equals 237.50 When I used the VLOOKUP before, the function pulled the very last 237.5 and the corresponding time value which is not correct for my needs. Any additional help would be appreciated. "PCLIVE" wrote: You can use VLOOKUP but your data will need to be in ascending order by the lookup column. =VLOOKUP("237.50",A1:B19,2,0) HTH, Paul "yazmaz" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I find a specific value in a random column of numbers
Perhaps this:
=INDEX(A1:B19,MATCH("237.50",A1:A19,0),2) HTH, Paul "yazmaz" wrote in message ... Thanks to all that responded but I can not put column A in ascending order because column A represents the emptying and then filling of a tank (volume) and Coulmn B represents the time in minutes to complete the process. The tank volume decreases to a certain point and then starts to increase until it hits 237.50 and then every volume after that equals 237.50 When I used the VLOOKUP before, the function pulled the very last 237.5 and the corresponding time value which is not correct for my needs. Any additional help would be appreciated. "PCLIVE" wrote: You can use VLOOKUP but your data will need to be in ascending order by the lookup column. =VLOOKUP("237.50",A1:B19,2,0) HTH, Paul "yazmaz" wrote in message ... 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 |
Reply |
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 |