Thanks for the help. I am confronted with a new scenario which I'll present
for help.

One worksheet titled geo I have a list of names b4 thru b18 and data in
k4thru k18. I want to transfere the data to worksheet titled miriam after
searching for the exact names. The names of the second worksheet are column
ax3 thru ax89. Hope this makes sense to you.

George

"RagDyer" wrote:

> First question:
>
> Replace error message with a null ( "" ), which can then be added:
>
> =IF(ISNA(MATCH(A1,'Sheet2'!$A$1:$A$10,0)),"",VLOOKUP(A1,
> 'Sheet2'!$A$1:$D$10, 4, 0)
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "George A. Yorks" <gyorks@comcast.net.(donotspam)> wrote in message
> news:D717F2F0-DDE4-485A-9909-E3CFF61BC1F9@microsoft.com...
> I keep saying thanks, your help is outstanding. I would like to ask two
> additional questions. ie: When I enter my formula into the cells of column
> A
> in a number of cells it returns a value in a few it returns#N/A. There is
> no data in those cases but with the #n?A when I try to add the columns will
> not do so as it cant enter a non digit. I'm using 0 for the last number in
> my formula. How best to get around this.
>
> Also I've copied a table from USA internet. In pasting to worksheet all the
> cells are obliterated and nothing is recognized by excel. The data is
> however recognized in (pardon me) lotus. Is there anyway of having my
> vlookup formula search 123 in place of a sheet in excel. =vlookup(a1,
> sheet2!$A$1:$j$31, 10,0). Hope these questions make sense to someone
>
> "Earl Kiosterud" wrote:
>
> > George,
> >
> > The 4 is the third parameter of the VLOOKUP function, and tells it to
> > retrieve the cell in the 4th column of the range being looked up in. Did
> I
> > say being looked up in? Oh, well.
> >
> > --
> > Earl Kiosterud
> > mvpearl omitthisword at verizon period net
> > -------------------------------------------
> >
> > "George A. Yorks" <gyorks@comcast.net.(donotspam)> wrote in message
> > news:8F924F5C-856D-48A0-9D3C-9BF538748E3D@microsoft.com...
> > > Thanks for the help. I know I'll fully understand the formula structure
> > > soon. One question, at end of formula ,4,0 what in fact does the 4 make
> > > reference to?
> > >
> > > "Ragdyer" wrote:
> > >
> > >> Try this:
> > >>
> > >> =VLOOKUP(A1, 'Sheet2'!$A$1:$D$10, 4, 0)
> > >>
> > >> --
> > >> HTH,
> > >>
> > >> RD
> > >>
> >
> >> -------------------------------------------------------------------------
> --
> > >> Please keep all correspondence within the NewsGroup, so all may benefit
> !
> >
> >> -------------------------------------------------------------------------
> --
> > >>
> > >> "George A. Yorks" <gyorks@comcast.net.(donotspam)> wrote in message
> > >> news:85A106A1-3EAC-45B1-81F1-E47139806E7B@microsoft.com...
> > >> > Thanks for the help. One further question.
> > >> > In the formul In sheet 2 $A$1:$b$10makes reference to two adjacent
> > >> columns.
> > >> > If there is a column between so there is data in a and c and none in
> b
> > >> > the
> > >> > result return err,the formula in this cell referes to cells that are
> > >> > currently emply. How to get around this. ie" if sheet two has data
> in
> > >> column
> > >> > a and column d.
> > >> >
> > >> > thanks
> > >> >
> > >> > George Yorks
> > >> >
> > >> > "Earl Kiosterud" wrote:
> > >> >
> > >> > > George,
> > >> > >
> > >> > > In B1 of sheet 1:
> > >> > > =VLOOKUP(A1, 'Sheet2'!$A$1:$B$10, 2, FALSE)
> > >> > >
> > >> > > Copy down with fill handle to B10.
> > >> > > --
> > >> > > Earl Kiosterud
> > >> > > mvpearl omitthisword at verizon period net
> > >> > > -------------------------------------------
> > >> > >
> > >> > > "George A. Yorks" <gyorks@comcast.net.(donotspam)> wrote in message
> > >> > > news:316947CC-1088-49F7-AEE2-3E81DE914D9D@microsoft.com...
> > >> > > > Trying to create a formula to do the following:
> > >> > > > Sheet 1 column A a list of personal names a1-a10
> > >> > > >
> > >> > > > Sheet 2 has list of names a1-a10 and list of dollar amounts
> colums
> > >> d1-d10
> > >> > > >
> > >> > > > want to search sheet one and if any name from sheet 2 found on
> > >> > > > sheet 1
> > >> > > > than
> > >> > > > the corresponding dollar amount is entered.
> > >> > > >
> > >> > > > Any help appreciated.
> > >> > > > --
> > >> > > > George
> > >> > >
> > >> > >
> > >> > >
> > >>
> > >>
> >
> >
> >
>
>