Cell Location in Array

  • Thread starter Thread starter BillCPA
  • Start date Start date
B

BillCPA

I have a table on Spreadsheet 'A' - O1:S1000. Is there some way to look up a
value from Spreadsheet 'B' in the table on 'A', and return either the row in
the table where the value was found, or the column where it was found, or the
cell address, or all of the above?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't located named range 3
Conditional Formatting Pivot Table Rows in Excel 2007 9
Having Blank Cells, etc. ? 1
Excel Typed text appears in wrong cell 0
Which Function to Use? Search an Array, Return a Row Value 1
VLOOKUP - Return value of the cell below the formula's answer 1
How to use vlookup in an array formula 2
What function would tell me the cell the information is in? 1

Back
Top