Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
You just need to sort your list ascending based on the first column. Then you can use a vlookup as follows: =vlookup(A1, A4:B10,2) The A4:B10 is the area where you have your data table shown in your original post. The vlookup will go to the nearest value that is less than or equal to it and then pull the second column. Let me know if you need a hand. Chad -- cvolkert ------------------------------------------------------------------------ cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380 View this thread: http://www.excelforum.com/showthread...hreadid=381077 |
#2
|
|||
|
|||
How do I get a cell in sheet 4 to = a cell in sheet 2? :) -- sam_360 ------------------------------------------------------------------------ sam_360's Profile: http://www.excelforum.com/member.php...o&userid=24516 View this thread: http://www.excelforum.com/showthread...hreadid=381077 |
#3
|
|||
|
|||
I dunno how we got here, but
=Sheet1!A1 put in any cell in Sheet2 will return the value in Sheet1 cell A1 Vaya con Dios, Chuck, CABGx3 "sam_360" wrote in message ... How do I get a cell in sheet 4 to = a cell in sheet 2? :) -- sam_360 ------------------------------------------------------------------------ sam_360's Profile: http://www.excelforum.com/member.php...o&userid=24516 View this thread: http://www.excelforum.com/showthread...hreadid=381077 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple formula help | Excel Worksheet Functions | |||
help with simple formula | Excel Worksheet Functions | |||
Excel Miscalculates simple formula..Help!! | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |