software

I have a workbook with 2 worksheets (Sheet1) and (Sheet2). I need to
look at (Sheet1) cell (AL3) if this cell is blank I then need to look
at Cells (F3) and (G3) to determine which row I need to use in
(sheet2).

I would be greatful for any help

Simon--
swestwood
------------------------------------------------------------------------
swestwood's Profile: www.excelforum.com/member.php...oamp;userid=31323
View this thread: www.excelforum.com/showthread...hreadid=520108Can you elaborate on
quot;I then need to look at Cells (F3) and (G3) to determine which row I need to
use in (sheet2)quot; ?

Give us one or two examples of values in F3 and G3 and what happens next.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;swestwoodquot; gt; wrote
in message ...
gt;
gt; I have a workbook with 2 worksheets (Sheet1) and (Sheet2). I need to
gt; look at (Sheet1) cell (AL3) if this cell is blank I then need to look
gt; at Cells (F3) and (G3) to determine which row I need to use in
gt; (sheet2).
gt;
gt; I would be greatful for any help
gt;
gt; Simon
gt;
gt;
gt; --
gt; swestwood
gt; ------------------------------------------------------------------------
gt; swestwood's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31323
gt; View this thread: www.excelforum.com/showthread...hreadid=520108
gt;
I agree with Bernard Liengme a clarification is necessary, but it sounds like
your trying to combine a (vertical lookup) with an (if statement), try this
link towards the bottom of the page.
www.contextures.com/xlFunctions02.html

quot;Bernard Liengmequot; wrote:

gt; Can you elaborate on
gt; quot;I then need to look at Cells (F3) and (G3) to determine which row I need to
gt; use in (sheet2)quot; ?
gt;
gt; Give us one or two examples of values in F3 and G3 and what happens next.
gt; best wishes
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email