LOOKUP Return relative

[seenfresh]

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

 

[mbb4331]

This sounds more like a code solution to me.

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

 

[seenfresh]

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]

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.