Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Adding a custom function to the default excel function list | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |