Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VLookup: Return Multiple Columns?
I have two worksheets and I can pull the ColB column of data over to where I
want it with vlookup but how can I then get columns C thru G over to my worksheet? I am trying to pull forecasted prices for the same row of information. Here is my current function formula: =VLOOKUP(H2,'[- Master.xls]Pricing'!$A$2:$G$4611,2,FALSE) It would be nice to have the 2 change to a three when I drag the formula to the right. And then drag again and have the 3 change to a 4, etc. Or what is the answer. Thanks in advance. The sheet I am pulling data from looks somewhat like this: ColA ColB ColC ColD ColE ColF ColG Part Number Year1 Year2 Year3 Year4 Year5 Year6 XXXX1111 $1.00 $1.25 $1.50 $1.75 $2.00 $2.25 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup to return 2 columns | Excel Discussion (Misc queries) | |||
Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
vlookup 3 columns all return same | Excel Discussion (Misc queries) | |||
Can I return multiple columns from a vlookup? | Excel Worksheet Functions | |||
Vlookup return multiple columns | Excel Worksheet Functions |