Need to get around limit of 7 nested functions

A

Amanda

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!!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB Function for Copy & Paste 0
Adding a big matrix in Word 2013 5
Insert Index into a Table 1
Nesting SUBTOTAL with SUMPRODUCT? 1
Need conditional formatting help!!! 1
Excel VBA macro, search - accumulate - delete original 0
match function with nested if 12
I need to add an IF condition to a formula 9

Top