Look up function-What I need to do is very tricky.

I have a workbook with 2 worksheets (Finished Panels) + (Edging Codes). What I need to do is very tricky. I need to select (AL3). Then check that Cell (R3) has data in it. If it has then look at cell (F3) to get the thichness of the panel. Then Look at the Product Range. And paste the value in cell (AL3) any help would be great.

Hi
Too vague. You say there are two sheets, but then your problem seems to
only apply to one sheet, and we don't know which!
You say "Then look at Product Range". Look at how? Look at where?? Is a
decision to be made based on a value???

regards
Paul

Could you please mail sample worksheet?

HTH
--
AP
mailto:[email protected]

"swestwood" <[email protected]> a écrit
dans le message de
news:[email protected]...
>
> I have a workbook with 2 worksheets (Finished Panels) + (Edging Codes).
> What I need to do is very tricky. I need to select (AL3). Then check
> that Cell (R3) has data in it. If it has then look at cell (F3) to get
> the thichness of the panel. Then Look at the Product Range. And paste
> the value in cell (AL3) any help would be great.
>
>
>
>
> --
> swestwood
> ------------------------------------------------------------------------
> swestwood's Profile:
http://www.excelforum.com/member.php...o&userid=31323
> View this thread: http://www.excelforum.com/showthread...hreadid=520098
>