Prev: apply/erase formatting, clear content, ...
Next: PLEASE HELP
From: owl on 17 May 2010 17:04
Hello,

I am looking to figure out how to use V Lookup with multiple values. I have
about 30 of the same name in column A (This is picked out of about 30.000
names in column A). How can I do this?

Thanks.
From: Pete_UK on 17 May 2010 17:19
You can use a helper column with a COUNTIF formula to turn those 30
multiple values into 30 unique values, by tagging a sequential number
onto the value. Then you can use an INDEX/MATCH combination to bring
the matching data across, either singly or for all values.

I could give you more details on how to do this if you could supply
more details of what data you have, how it is laid out (sheet names,
columns used etc) and what you want to achieve with it.

Hope this helps.

Pete

On May 17, 10:04 pm, owl <o...(a)discussions.microsoft.com> wrote:
> Hello,
>
> I am looking to figure out how to use V Lookup with multiple values. I have
> about 30 of the same name in column A (This is picked out of about 30.000
> names in column A).  How can I do this?
>
> Thanks.

From: Ashish Mathur on 17 May 2010 19:46
Hi,

you may refer to my article here

http://office.microsoft.com/en-gb/excel/HA012260381033.aspx

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"owl" <owl(a)discussions.microsoft.com> wrote in message
news:8DAA288A-F29B-4AA8-A0A4-95F9C02654B5(a)microsoft.com...
> Hello,
>
> I am looking to figure out how to use V Lookup with multiple values. I
> have
> about 30 of the same name in column A (This is picked out of about 30.000
> names in column A). How can I do this?
>
> Thanks.

 | 
Pages: 1
Prev: apply/erase formatting, clear content, ...
Next: PLEASE HELP