Formula to return the range of certain cells

[Umair Ali]

Hi,
I have a 4* 4 table where the first column contains text
and the other 3 columns contains percentages. I am using a
vlookup in another cell and essentially I want the vlookup
to look for one of the 4 words in the first column and be
able to return the row reference for that heading. For
example, if 1st row, 1 st column is "A" and the associate
percentages in the same row as A are 20, 50 and 50%. I
want the vlookup to return row1,column2,3,4. Just a
reference to the 3 numbers associated with A is what I
really want.

I have been trying to do this with vlookup but it only
allows me to get information for 1 number and not all
three. I need this because I am using a sumproduct
function later on and I want the three percentage numbers
as references so that I can multiply them with 3 other
numbers.

I know its pretty confusing but if you need clarification
then feel free to ask me.

Umair

 

[Jason Morin]

Based on what you wrote in your post, I would simply do 3
VLOOKUP formulas that pull your data into 3 different
cells. If you merge the data into one string, it makes it
much more difficult (but not impossible) to do
calculations on the separate parts downstream.

HTH
Jason
Atlanta, GA