LinkBack URL
About LinkBacks
I want to find out if a number or text exist in a column. All I know about this column is the number (i.e. 19). This number can change. Is it possible to use MATCH or something else if I only know the column number?
I want to find out if a number or text exist in a column. All I know about this column is the number (i.e. 19). This number can change. Is it possible to use MATCH or something else if I only know the column number?
Last edited by mkvassh; 10-07-2010 at 10:28 AM.
Not sure exactly what you mean...
To find if a value exists in a column you can use:
=Match("X",S:S,0)
will look for "X" in column S.. return a position or #N/A error.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Maybe this?
=ISNUMBER(MATCH("mytext", INDIRECT(ADDRESS(1,19)&":"&ADDRESS(10000,19)), 0))
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
You suggestion will work, JBeaucaie. Thank you :-)
If that is the case, then this simpler and non-volatile suggestion should work too.
=ISNUMBER(MATCH("x",INDEX(A1:Z1000,0,19),0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks