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.
http://www.contextures.com/xlFunctions02.html

"Bernard Liengme" wrote:

Can you elaborate on
"I then need to look at Cells (F3) and (G3) to determine which row I need to
use in (sheet2)" ?

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