Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Compare value to Lookup table min & max, return contents of 3rd ce
Hi
Excel 2003 As per the example created below I'm using a formula to return a number value (in D1) that can be anywhere between 0.00 & 6.00 (including 0.00 & 6.00) I want my formula (in E1) to compare the value (D1) to min & max values in a table (A4:A9), so whichever min & max my value equals or falls between, it will return the value in a 3rd cell adjacent the appropriate min & max cells(C4:C9) : A B C D E 1 4.75 Pink 2 3 Min Max 4 0.00 0.99 Blue 5 1.00 1.99 Green 6 2.00 2.99 Yellow 7 3.00 3.99 Red 8 4.00 4.99 Pink 9 5.00 6.00 Orange My calculated value is in D1 The formula (in E1) needs to compare D1 with the table in A4:B9 then return the corresponding value (colour) from C4:C9 and place it in E1 Hope my explanation is clear enough, thanks for looking & hope you can help. Cheers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to return an address from a lookup into a table? | Excel Discussion (Misc queries) | |||
Lookup part of a cell's contents and return value of entire cell | Excel Discussion (Misc queries) | |||
compare the contents of one range of cells with the contents of a. | Excel Discussion (Misc queries) | |||
need Lookup table to return null or zero | Excel Worksheet Functions | |||
Return cell contents based on conditional lookup | Excel Worksheet Functions |