"Sumif" for text

S

Stan

Hi,

I've used "sumif" to pick up certain entities from a large
schedule. Is there a way to pick up related text (not
numbers) in the same manner?

For example,
sumif(A:A,a1,F:F) where A:A is list of entities, F:F is
numbers. I need to also pick up the remarks in column G:G
related to numbers in F:F.

Thanks for your help.

Stan
 
F

Frank Kabel

Hi Stan
and how do you want themto be displayed if there are more than one
matches?
 
G

Guest

Frank,

I don't think there will any duplicates.
-----Original Message-----
Hi Stan
and how do you want themto be displayed if there are more than one
matches?

--
Regards
Frank Kabel
Frankfurt, Germany



.
Click to expand...
 
F

Frank Kabel

Hi
if there could be only one row which matches the search criteria use
=VLOOKUP(search_value,A1:G1000,7,0)
 
S

Stan

Frank.

Let me try to explain again.
The w/p I'm putting together (file#1) has 500 entities and
the original w/p (file#2) has about 25,000 entities.

In file#1, I need to pick up a number from column F:F in
file#2, and also need to pick up a related text in column
G:G in file#2 if any of the entity numbers in column A:A
in file#2 is "123".
I can use "sumif" to pick up numbers, but I need a similar
function for non-numeric contents.
The number and the text are located in the same row.

Please help.
Thanks
 
F

Frank Kabel

Hi
if you only expect one match VLOOKUP should work. If there could me
more than one match you have to explain how you wnat to combine these
results.
You may post some example rows of both files (plain text - no
attachment please) and describe based on this example your expected
result
 
Top