Provide a list of all cells that meets this criteria

[Senor Martinez]

I dont even know where to begin with this one...

If Row A has the digits 23, 83, 849, 759 and Row AL has the value of
RESEARCH then provide me a list of all the accounts in row B that meets those
standards... any ideas??!! Thanks in advance

 

[Pete_UK]

I think you are getting your rows and columns mixed up - columns have
letter(s) to identify them and rows are numbered.

That being said, I don't understand what you want to do, so perhaps
you can try to describe your problem again ...

Pete

 

[Glenn]

I dont even know where to begin with this one...

If Row A has the digits 23, 83, 849, 759 and Row AL has the value of
RESEARCH then provide me a list of all the accounts in row B that meets those
standards... any ideas??!! Thanks in advance

Try either AutoFilters or PivotTables.

http://www.contextures.com/xlautofilter01.html

http://peltiertech.com/Excel/Pivots/pivotstart.htm

 

[Senor Martinez]

Pete you are correct my mistake!!

If Column A has the digits 23, 83, 849, 759 and Column AL has the value of
RESEARCH then provide me a list of all the accounts in Column B that meets
those
standards... any ideas??!! Thanks in advance