Not sure about your stup, are you typing INTO a merged cell, or looking
up a table of merged cells?
Valid is

=vlookup(mergedcell,table,2,false)

=vlookup(A1&B1,table,2,false)

does this help?

--

Regnab Wrote:
In column A I have group titles. In column B I have the individual
elements. So for example, the location in ColA is "Italy", and then
the
company names located in Italy are in ColB. I have merged the rows in
Col A so that if I hide some but not all the rows corresponding to the
companies, the location ("Italy") appears for those still showing.

I would like to be able to use VLookup so I could type in a company
name and it would return the location. However, because it is a merged
cell, it returns "0". Anyone got any stunning ideas how I can do this
or will I need to unmerge in order to get a result??

Cheers

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