I think it would only be possible with VB code, with a Worksheet change
event on column B (or the pressing of a button) to trigger a Filter
parameter being set for column A to the value in column A of the row
concerned.

Does that sound like what you need. ie, that a change to an item in
column B (ComA) causes a filter to be set on the value in column A
(Italy)?

--

Peo Sjoblom Wrote:
No because merged A1:A3 = A1, there is no A2 or A3 with any value and
all
references to them will always return a zero, however a vlookup looks
up in
the leftmost column and returns its value from indexed columns to the
right
so even if it would be possible to use merged cells it wouldn't work

You can use index(A2:A5,match(lookup_value,B2:B5,0)) but not with
merged
cells in A

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Regnab" wrote in message
ups.com...
I'm looking up the value that is in a merged cell. So just say there
are 3 companies in Italy - ComA, ComB and ComC in B1, B2 and B3.
A1:A3
has been merged to display "Italy". I want to use VLookup so I can
enter ComA and it will display "Italy". Starting to think it may not
be
possible with a merged cell...

Thanks for your help,

Reg



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=539128