| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need to get around limit of 7 nested functions
Hi,
I have two columns with 24 rows of information each. If the value in cell B7 corresponds to a value in column F, then I want the value in the same row in column G to be displayed in B17. I know I can use a nested IF funtion to get this to work for the first few rows, but how do I get beyond that? Thanks!!! -- Amanda |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to get around limit of 7 nested functions
Try this:
=VLOOKUP(B7,F:G,2,0) -- Biff Microsoft Excel MVP "Amanda" wrote in message ... Hi, I have two columns with 24 rows of information each. If the value in cell B7 corresponds to a value in column F, then I want the value in the same row in column G to be displayed in B17. I know I can use a nested IF funtion to get this to work for the first few rows, but how do I get beyond that? Thanks!!! -- Amanda |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Need to get around limit of 7 nested functions
Read a good book in Excel? Perhaps one by John Walkenbach.
http://j-walk.com/ss Tyro "Amanda" wrote in message ... Hi, I have two columns with 24 rows of information each. If the value in cell B7 corresponds to a value in column F, then I want the value in the same row in column G to be displayed in B17. I know I can use a nested IF funtion to get this to work for the first few rows, but how do I get beyond that? Thanks!!! -- Amanda |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit to nested IF(ISNUMBER(SEARCH)) functions? | Excel Worksheet Functions | |||
| Nested If Limit | Excel Worksheet Functions | |||
| Get Past the 7 Nested IF limit | Excel Worksheet Functions | |||
| limit of 7 nested functions? | Excel Worksheet Functions | |||
| Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) | |||
Linear Mode
