Look up function
 

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

Look up function
 

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

Look up function
 

Could you please mail sample worksheet?

HTH
--
AP


"swestwood" a écrit
dans le message de
...

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