having one more than one column index number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Want the column index number to pull from 3 different cells and show the
three numbers?
 
=IF(C19="","",VLOOKUP(C19,INDIRECT(B19&"List"),2,FALSE))
That is the formula I am using and it says to show the second column (2),
but I want it to show columns 2, 3, 4, 5, 6
 
=IF($C19="","",VLOOKUP($C19,INDIRECT($B19&"List"),COLUMN(B1),FALSE))

Just drag copy across to get column 3, 4, 5, and 6

If you mean that you want the results from columns 2 - 6 to all appear in
the same cell, I can't help you!

Biff
 
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

Convert Number to Text for Index/Match 1
vlookup column index number argument 6
Using SUM + INDEX in array formula 5
VLookup Column Reference - can it increment when copying to subseq 3
INDEX return multiple columns 1
Reference the same cell based on tab name 1
Vlookup, Column Index Num and Autofill 9
Linking value of cell on one worksheet to a column on another work 1

Back
Top