Hi,
There's got to be a way to do this (mail merge style perhaps...)
I would like to insert the entry/ies under a heading in a table in one
worksheet whenever that heading matches the data entered in a separate
worksheet.
Presently I can find no way to do this in Excel.
Please can you suggest a way to do this...
Thanks
G

Need a better more detailed explanation.

The more details you provide, the easier it is to find a solution!

Biff

"Gabbon" wrote in message
...
Hi,
There's got to be a way to do this (mail merge style perhaps...)
I would like to insert the entry/ies under a heading in a table in one
worksheet whenever that heading matches the data entered in a separate
worksheet.
Presently I can find no way to do this in Excel.
Please can you suggest a way to do this...
Thanks
G

Hi,
Thanks for your reply.
I have a table with three headings (could be more soon), and a sub-entry
under each heading.
I also have a row in which those headings appear occasionally. I am looking
for a way to enter the sub-entry of those headings in the row underneath at
every point at which those three headings appear.
(This is pretty much the style of the Word mail merge operation).
Can you point me in the right direction? Or any direction--I have looked
through help and can't locate where to find the answer
Thanks,
Gabbon

"Biff" wrote:

Need a better more detailed explanation.

The more details you provide, the easier it is to find a solution!

Biff

"Gabbon" wrote in message
...
Hi,
There's got to be a way to do this (mail merge style perhaps...)
I would like to insert the entry/ies under a heading in a table in one
worksheet whenever that heading matches the data entered in a separate
worksheet.
Presently I can find no way to do this in Excel.
Please can you suggest a way to do this...
Thanks
G

If your headings are in A1:C1 and sub-headings in A2:C2

If you want the appropriate sub-heading to appear in E11, for instance,
when you put one of the headings in E10 then one way would be to use
this formula in E11

=HLOOKUP(E10,$A$1:$C$2,2,0)

You can copy this formula along the row


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=503512

Perfect!
Thank you very much--I appreciate it
(I still need to find a way to have the cell appear blank when the sub-entry
data is blank. Entering a space does the trick, but I'm sure there is
another formula to use to return a blank cell rather than a cell with 0 in it)
Gabon

=IF(formula="","",formula)

--
Regards,

Peo Sjoblom

Portland, Oregon




"Gabbon" wrote in message
...
Perfect!
Thank you very much--I appreciate it
(I still need to find a way to have the cell appear blank when the
sub-entry
data is blank. Entering a space does the trick, but I'm sure there is
another formula to use to return a blank cell rather than a cell with 0 in
it)
Gabon