Vlook Question

  • Thread starter Thread starter Denise
  • Start date Start date
Denise,

One way

=VLOOKUP($A$1,$B$4:$G$10,COLUMN(B2),FALSE)
Start in column 2 of the table and dragged right becomes column 3 etc
or
=VLOOKUP($A$1,$B$4:$G$10,ROW(B2),FALSE)
same effect dragged down

Mike
 
Thank you so much, that worked like a charm...


Mike H said:
Denise,

One way

=VLOOKUP($A$1,$B$4:$G$10,COLUMN(B2),FALSE)
Start in column 2 of the table and dragged right becomes column 3 etc
or
=VLOOKUP($A$1,$B$4:$G$10,ROW(B2),FALSE)
same effect dragged down

Mike
Click to expand...
 

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

Dynamic col_index_num in VLOOKUP? 5
VLOOKUP and using a Name in the col_index_num 2
Nested functions using array/range names 3
vlookup 2
vlookup from right to left 2
Vlook-up in report with column Expansion 5
Excel 3
#N/A error with VLOOKUP function 3

Back
Top