Lookup Function help

Y

Yunus

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 set this up in Sheet 2 e.g
In Sheet2 Cell A2, Lookup in Sheet 1 Cell B5 if not blank then return
B5
In Sheet2 Cell B2, Lookup in Sheet 1 Cell B5 if not blank then return
A5
In Sheet2 Cell C2, Lookup in Sheet 1 Cell B5 if not blank then return
F5
Can some please help, thanks
 
Y

Yunus

yunus786 said:
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 set this up in Sheet 2 e.g
In Sheet2 Cell A2, Lookup in Sheet 1 Cell B5 if not blank then return
B5
In Sheet2 Cell B2, Lookup in Sheet 1 Cell B5 if not blank then return
A5
In Sheet2 Cell C2, Lookup in Sheet 1 Cell B5 if not blank then return
F5
Can some please help, thanks
Click to expand...

Sorry in the e.g It Should Lookup in Sheet1 Cell C5, not B5
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup function help required. 0
Looking up a Cell and returning correspong Cell value 0
HELP: IF Statement between Dates for Reverse Index failing 0
VBA Coding Help for Beginner 0
IF function says too many nested 1
Inequalities Function 3
Payment calculation 1
combine three if functions 3

Top