creating a formul

I've used the following formula =vlookup(b4,sheet3!$c$1:$m$31,11,0) The
correct data is transfered to the first cell in the column all other cells
receive #N/A a value is not available to the formula or function. There is
however data to be transfered.Any help appreciated

"George A. Yorks" wrote:

> 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
> >
> >
> >

Well, Excel isn't seeing a match. For one of the formulas that you expect to
return a value, what is in column B, and what is the matching data in column C
or your table on Sheet3? Could the problem be that you have numbers in one
place and text that looks like a number (but is stored as text) in the other?
If so, they won't match, e.g. 1 doesn't match "1"


On Mon, 21 Feb 2005 13:55:04 -0800, George A. Yorks
<gyorks@comcast.net.(donotspam)> wrote:

>I've used the following formula =vlookup(b4,sheet3!$c$1:$m$31,11,0) The
>correct data is transfered to the first cell in the column all other cells
>receive #N/A a value is not available to the formula or function. There is
>however data to be transfered.Any help appreciated
>
>"George A. Yorks" wrote:
>
>> 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
>> >
>> >
>> >

Ihave tried to copy data from USA Today report. When I past to excel
worksheet all cells are obliterated. Does this account for the data not
being recognized. If so is there anything that can be done to make this data
useable??

Thanks for all the help and information

"Myrna Larson" wrote:

> Well, Excel isn't seeing a match. For one of the formulas that you expect to
> return a value, what is in column B, and what is the matching data in column C
> or your table on Sheet3? Could the problem be that you have numbers in one
> place and text that looks like a number (but is stored as text) in the other?
> If so, they won't match, e.g. 1 doesn't match "1"
>
>
> On Mon, 21 Feb 2005 13:55:04 -0800, George A. Yorks
> <gyorks@comcast.net.(donotspam)> wrote:
>
> >I've used the following formula =vlookup(b4,sheet3!$c$1:$m$31,11,0) The
> >correct data is transfered to the first cell in the column all other cells
> >receive #N/A a value is not available to the formula or function. There is
> >however data to be transfered.Any help appreciated
> >
> >"George A. Yorks" wrote:
> >
> >> 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
> >> >
> >> >
> >> >
>
>

I understand that excel is not seeing a match. But if I do the following the
file is recognized. I copy the file(containing a column of names and column
of numbers) and past to excel.I then copy from excel to lotus 123 and then
from lotus 123 back to excel. Is there any reason for this and is there any
other, less cumbersome, proceedure???

"George A. Yorks" wrote:

> Ihave tried to copy data from USA Today report. When I past to excel
> worksheet all cells are obliterated. Does this account for the data not
> being recognized. If so is there anything that can be done to make this data
> useable??
>
> Thanks for all the help and information
>
> "Myrna Larson" wrote:
>
> > Well, Excel isn't seeing a match. For one of the formulas that you expect to
> > return a value, what is in column B, and what is the matching data in column C
> > or your table on Sheet3? Could the problem be that you have numbers in one
> > place and text that looks like a number (but is stored as text) in the other?
> > If so, they won't match, e.g. 1 doesn't match "1"
> >
> >
> > On Mon, 21 Feb 2005 13:55:04 -0800, George A. Yorks
> > <gyorks@comcast.net.(donotspam)> wrote:
> >
> > >I've used the following formula =vlookup(b4,sheet3!$c$1:$m$31,11,0) The
> > >correct data is transfered to the first cell in the column all other cells
> > >receive #N/A a value is not available to the formula or function. There is
> > >however data to be transfered.Any help appreciated
> > >
> > >"George A. Yorks" wrote:
> > >
> > >> 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
> > >> >
> > >> >
> > >> >
> >
> >