LOOKUP Return relative

seenfresh

Well-known Member
Joined
Jul 12, 2006
Messages
1,141
I would like to perform a lookup into Column A of a w but would like to return the values associated with the lookup from column C:V

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

In this case my col_index_num would be everyvalue in each cell range C:V

I can't put just $C:$V because it would return the column V values only

Any help would be much appreciated

Thanks

Sean
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

mbb4331

Board Regular
Joined
Dec 22, 2005
Messages
152
This sounds more like a code solution to me.

Are you trying to concatenate each of the looked-up values into one cell?
 

seenfresh

Well-known Member
Joined
Jul 12, 2006
Messages
1,141
Ya it does seem like a code solution I guess

I am not looking to concatenate the values all in one cell I was just trying to establish a faster way of getting all the info from each column eg. C:V associated with c/A and basically inserting the same layout but in another worksheet

Trying to save time instead of finding each Product in Column A that I want and selecting the entire row and pasting into another w was wondering if a formula or code could enhance this process through a lookup up for the value in c/A?

Thanks

Sean
 

mbb4331

Board Regular
Joined
Dec 22, 2005
Messages
152
Here's an idea:

=INDIRECT(ADDRESS(MATCH($G$5,$A$1:$A$4,0),COLUMN()))

In G5, I have a the Product Name.

My lookup range includes a total of 4 rows (hence $A$1:$A$4. Increase this accordingly). Put this cell in column A below the lookup range and copy across to column CV.
 

Forum statistics

Threads
1,141,599
Messages
5,707,311
Members
421,502
Latest member
PULBAG

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top