Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Lookup function help required.
Hi In Sheet 1 I have a Table Array (A5:W352), If I filter out the blank cells in Column C I get the desired display in Columns A, B, F, G & K but in the wrong order... I want to look this up in Sheet 2 e.g In Sheet2 Cell A2, Lookup in Sheet 1 Cell C5 if not blank then return C5 In Sheet2 Cell B2, Lookup in Sheet 1 Cell C5 if not blank then return A5 In Sheet2 Cell C2, Lookup in Sheet 1 Cell C5 if not blank then return F5 Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup formula required | Excel Discussion (Misc queries) | |||
Help please - Lookup required - not sure! | Excel Worksheet Functions | |||
If & Lookup & match Formula Required! | Excel Discussion (Misc queries) | |||
Macro Required for Lookup Function | Excel Programming | |||
Some sort of lookup formula required | Excel Worksheet Functions |