is there a macro or anything that can make it easier to find a matching
name from a different sheet and return a value in a cell that
corrosponds to the name? having too much trouble with lookup formulas


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=514275

Well, VLOOKUP can be a bit confusing, so if you will offer up some idea of
what your data looks like and what you are seeking, I'm sure a solution is
possible.

But lets try this, on sheet 2 in A1:A3 enter 1, 2, 3.
In B1:B3 enter a, b, c.

On sheet 1 in cell B1 enter =VLOOKUP(A1,SHEET2!A1:B3,2,0)

On sheet 2, cell A1 enter 1, 2, or 3.

B1 returns "a", "b" or "c".

HTH
Regards,
Howard

"darkbearpooh1"
wrote in message
news:darkbearpooh1.23ihdn_1140411302.0227@excelfor um-nospam.com...

is there a macro or anything that can make it easier to find a matching
name from a different sheet and return a value in a cell that
corrosponds to the name? having too much trouble with lookup formulas


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile:
http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=514275

Hi!

You don't necessarily need a lookup formula. If the data to be returned is
numeric and there's only one instance of the "lookup" value you can use
Sumif or Sumproduct.

Just an observation:

You're using a lot of coded VBA procedures to do what simple worksheet
functions can do.

Biff

"darkbearpooh1"
wrote in message
news:darkbearpooh1.23ihdn_1140411302.0227@excelfor um-nospam.com...

is there a macro or anything that can make it easier to find a matching
name from a different sheet and return a value in a cell that
corrosponds to the name? having too much trouble with lookup formulas


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile:
http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=514275

my problem lies and i think this is where i am getting confused,

the names i need to match are all in a row down the left side of the
totals sheet
no particular order and they can't be in any particular order.. i read
something about stuff has to be in ascending order? ok not only that
the names they will be looking for from the other sheet is in two
different columns to match two different columns of data ... what i
mean is say sheet 1 is my count sheet,
COLUMN A7:A47 has a list of names. so need to look at the next sheet
and see if the name is on it and it matches the name on sheet 1 and if
so return a value in a column related to it ... so the names on the
sheet 2 are in columns H28:H46and columns BC28:BC46 and matches the
data in column I27:I46 and AY28:AY46 Any ideas?

I think i have to many macros too but i just can't figure out a formula
for that and i think the other one doesn't look at the other side for
names and corresponding information?


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=514275

=IF(ISNA(MATCH($A7,INDIRECT(B$5&"!H28:H46"),0)),"" ,SUMIF(INDIRECT(B$5&"!H28:H46"),$A7,INDIRECT(B$5&" !I28:I46")))



ok, this function is working fine but how can i make it look not only
down column h to find the answer in column I but also look down column
BC to find the answer in column AY ? Thats the only problem i am having
now ill post the file so you can examine it.

Got to go to work now ill check back tonight. Thanks!
Biff i had to add more columns to get another function to work that Bob
helped me with but i figured out how to match it back up to the correct
columns now so its working again but, it doesn't apear to be looking at
the other side and returning matches for names on the other side of the
schedule. TIA


+-------------------------------------------------------------------+
|Filename: LINEBARtest21.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4379 |
+-------------------------------------------------------------------+

--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=514275

not sure if that was easy to understand or not so i figured i would try
to elaborate, i need to lookup names on my count sheet if they are on
the second sheet and give the number that corresponds to the name in a
different cell but the problem is the names are down two seperate
columns and so is the numbers that corrospond to the names TIA for any
help especially those who have been helping me for awhile!! I almost
have exactly what i need =)


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=514275

I'll take a look at your file tomorrow if no other replies before then.

Biff

"darkbearpooh1"
wrote in message
news:darkbearpooh1.23kafb_1140495602.7713@excelfor um-nospam.com...

not sure if that was easy to understand or not so i figured i would try
to elaborate, i need to lookup names on my count sheet if they are on
the second sheet and give the number that corresponds to the name in a
different cell but the problem is the names are down two seperate
columns and so is the numbers that corrospond to the names TIA for any
help especially those who have been helping me for awhile!! I almost
have exactly what i need =)


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile:
http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=514275

Thanks Biff! tried to figure out on my own, I even posted another
question that if answered might help me solve it. So far no luck


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=514275

Here's your file:

http://s48.yousendit.com/d.aspx?id=1...X02741VQ4SDH4T

I only put the formula in the first row. You'll need to copy it down to the
others!

Just a side note: In testing, I cleared the name Carmen from sheet Monday
cell H28 and that caused your udf to return a #NAME? error that propagated
to the Block sheet!

Biff

"darkbearpooh1"
wrote in message
news:darkbearpooh1.23lexn_1140548107.3818@excelfor um-nospam.com...

Thanks Biff! tried to figure out on my own, I even posted another
question that if answered might help me solve it. So far no luck


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile:
http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=514275

i am at work ill be home shortly and dl it to check it out... Thanks!
Was pulling my hair out on that because i was so d@#$ close to having
it!


--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile: http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=514275