Is there something like a SUMIF that just returns the info. in a c
The cell I want to return is not numeric.
Or maybe an IF - that checks a whole column of data..& returns a cell when it is true. |
Is there something like a SUMIF that just returns the info. in a c
Yes, you need to be more specific with what you are looking up and what you
want it to return =INDEX(A:A,MATCH("X",B:B,0)) if it finds X in column B it will return what's in A in the same row and if not found it will return #N/A You can also look at VLOOKUP -- Regards, Peo Sjoblom "markholt" wrote in message ... The cell I want to return is not numeric. Or maybe an IF - that checks a whole column of data..& returns a cell when it is true. |
All times are GMT +1. The time now is 05:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com