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