VLOOKUP all column

[parbynat]

Here's hoping this is possible
I have this-
A B C D
1 a
2 1 b
3 c

When I use lookup value 1 in A2 it returns b in D2, but is it possible to also return a in D1 and c in D3.
Basically all of column B to be shown in column D

Thanks

[saravnepali]

Its not still clear what you are after.

You can use vlookup

This formula goes to D1 and just drag it down for lookup value on A1 & table $A$1:$B$3

Make sure use the $ as it has to be fixed when you use it for different rows.

Please Login or Register  to view this content.

Basically all of column B to be shown in column D

Thanks

If you just want that you can simply say put on Column D cells D1

Please Login or Register  to view this content.

and then drag down

If this is not what you are after then attach excel sheet with sample data

[parbynat]

I should have checked how it looked before I posted as a, b and c are all in column B.
Attachment 651331

[saravnepali]

I should have checked how it looked before I posted as a, b and c are all in column B.
Attachment 651331

attachment doesnt work

[parbynat]

Sorry I am not savvy in doing this.
I'll try again

[Pete_UK]

Follow the instructions given in the yellow banner at the top of the screen to attach a file. A more-detailed set of instructions is given below:

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Don't try to use the Paperclip icon for attachments, as it doesn't work on this forum.

Hope this helps.

Pete

[AliGW]

The attachment does not really help. It shows this:

Excel 2016 (Windows) 32 bit

	A	B	C	D
1		a
2	1	b		b
3		c

Sheet: Sheet1

[parbynat]

https://www.excelforum.com/attachmen...1&d=1574682141

[Pete_UK]

You could put this formula in D1:

=IF(COUNTA(A:A),B1&"","")

and copy it down. Then if you have no values in column A then column D cells will show as blanks, but if you put any value in any cell in column A then the values from column B will show in column D. Is that what you want?

Hope this helps.

Pete

[saravnepali]

try this formula and drag it to the range as needed till D3

Please Login or Register  to view this content.

[parbynat]

Thanks for the replies

=IF(COUNTA(A:A),B1&"","") works for me

Cheers

[Pete_UK]

Glad to hear it.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete