Looking up a Cell and returning correspong Cell value

Y

Yunus

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 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
 

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
Lookup Function help 1
Junp start my Select Case Macro 12
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
change cell color depending on two cell values 1
How to do an IF statement that copy data based on a partial match 0
VBA Coding Help for Beginner 0
Dealing with the error: unable to filter on excel hc home school 0

Top