| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Exceeding the limit for Nested IFs
Hi Beard,
I think this is what you are looking for: =INDEX(PB!A1:B8;MATCH(B3;(PB!A1:A8);0);2) HTH Sige |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum limit and marking | Excel Worksheet Functions | |||
| Is there a limit to number of successive IF-THEN statements? | Excel Discussion (Misc queries) | |||
| Make the row limit of excel flexible -not fixed at 65536. | Excel Discussion (Misc queries) | |||
| Limit to the number of items in a cell | Excel Worksheet Functions | |||
| How do I add a limit line to a chart, so I can see where a data p. | Charts and Charting in Excel | |||
Threaded Mode
