Referencing columns values in rows

  • Thread starter Thread starter Pottsz
  • Start date Start date
P

Pottsz

On Sheet A, cells A1:A100, I want to reference the values from Sheet B, cells
B2:b101. Is there an easy way to accomplish this?
 
Put this on Sheet A, in cell A1:

=if('Sheet B'!b2="","",'sheet b'!b2)
and drag down 99 more rows.
 
You must log in or register to reply here.

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

Referencing columns values in row 1
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Help to create a macro 2
Vlookup cell reference 6
Referencing a cell even if its contents are moved moved/replaced 6
Complicated Formula 5
modify all formula references in multiple cells 3
Need help with SUMPRODUCT 1

Back
Top