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