Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 8
Default compare 2 column cells and return the adjacent columns cells data of the cell

In cell (P4) there is a formula that gives a number in C-mils (example "89268") based on several manualy inputer numbers.
I have a chart that has (AT4) through (AT33) each row of this column has a higher C-mill number example (AT14) = 83690 and (AT15) = 105600. in the column to the right of (AU) is a I want to reference back to (Q4).

such as the number in P4 is =(AT14) and <(AT15) and I want the number in (AU15) "1/0" is returned to (Q4).

remember the number in (P1) could be any number between "1 and 2,000,000" and this range is not divided equaly between cells (AT4) and (AT33). The number to the right in Column (AU) must be the cell that is the greater of the 2 cell number of the 2 adjacent cells in Column (AT) =(AT14) <(AT15).
  #2   Report Post  
Junior Member
 
Posts: 8
Default

Quote:
Originally Posted by trebor57 View Post
In cell (P4) there is a formula that gives a number in C-mils (example "89268") based on several manualy inputer numbers.
I have a chart that has (AT4) through (AT33) each row of this column has a higher C-mill number example (AT14) = 83690 and (AT15) = 105600. in the column to the right of (AU) is a I want to reference back to (Q4).

such as the number in P4 is =(AT14) and <(AT15) and I want the number in (AU15) "1/0" is returned to (Q4).

remember the number in (P1) could be any number between "1 and 2,000,000" and this range is not divided equaly between cells (AT4) and (AT33). The number to the right in Column (AU) must be the cell that is the greater of the 2 cell number of the 2 adjacent cells in Column (AT) =(AT14) <(AT15).
I have used this formula to find the information in the columns "=VLOOKUP(P8,$AT:$AU,2,0)" however this will not take into account that (P8) may never match the information in column (AT) of the table, what I need is the next higher value in the column, lets say, in column (AT) cell (AT7) is less than (P8) and cell (AT8) is greater than (P8) what I would like is... if (P8) = (AT7) get (AU7) and if (P8) is (AT7) but < or = to (AT8) then get (AU8)

this is the table I am pulling data from, if I input 30128 in cell (P8) I want the cells in (AT) referenced to find the correct information in (AU) in this case the answer I am looking for is (AU) "4"

(AT) (AU)
C-mils GAUGE
1620 18
2580 16
4110 14
6530 12
10380 10
16510 8
26240 6
41740 4 <====<
52620 3
66360 2
83690 1
105600 1/0
133100 2/0
167800 3/0
211600 4/0
250000 250kcm
300000 300kcm
350000 350kcm
400000 400kcm
500000 500kcm
600000 600kcm
700000 700kcm
750000 750kcm
800000 800kcm
900000 900kcm
1000000 1000kcm
1250000 1250kcm
1500000 1500kcm
1750000 1750kcm
2000000 2000kcm
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare 1 cell to column of cells returning adjacent cells info? Mr. Fine Excel Worksheet Functions 1 April 15th 10 07:36 PM
Add cells on two adjacent rows but non-adjacent columns Eve Excel Worksheet Functions 14 October 20th 09 02:32 AM
Help! Compare one cell against a whole column, report adjacent cel Spam spam bacon spam Excel Worksheet Functions 4 November 5th 08 07:54 PM
Compare two cells and return certain value in third cell hurairah Excel Worksheet Functions 3 July 19th 06 03:44 AM
compare adjacent cells and calculate averages Marquismarce Excel Worksheet Functions 5 May 17th 06 09:46 AM


All times are GMT +1. The time now is 09:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"