| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup formula?
I have the following (Col A & B is a Table);
A B C D 1 30 31 (Formula Result) 2 32 34 (Formula Result) C1 is larger than b1 but smaller than b2 so the result is A1 or 1. Is there a formula that can do this for me? -- Kfry57 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lookup formula?
try,
=if(and(c1b1,c1<b2),a1,false) hth regards from Brazil Marcelo "Kfry57" escreveu: I have the following (Col A & B is a Table); A B C D 1 30 31 (Formula Result) 2 32 34 (Formula Result) C1 is larger than b1 but smaller than b2 so the result is A1 or 1. Is there a formula that can do this for me? -- Kfry57 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| How do I lookup a value in a array that is not in ascending order | Excel Worksheet Functions | |||
| formula to lookup table in another Worksheet please | Excel Worksheet Functions | |||
| How do I have a formula lookup a sheetname? | Excel Worksheet Functions | |||
Linear Mode
