LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 148
Default Return cell address of a cell based on contents of cell.

I have a list (sheet1) of about 300 items (a1:a300) that appear in random
locations on sheet 2 of my workbook (a1:cf13). I want to find the items in
my list a1:a300 on sheet 2 and return their location (cell address) to
b1:b300.

If you know whether or not this can be done I would greatly appreciate it.
I have searched the forum for something similar to this but cant find what I
am looking for. I found a couple that use the address function with the max
function but that seems to just be for a single row or column. I am trying to
search through a range about 13x83.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
return a cell address based on a matched value.. Dave F[_2_] Excel Discussion (Misc queries) 4 January 3rd 08 07:00 PM
Comparing cell contents, know cell address molsansk Excel Discussion (Misc queries) 4 December 10th 07 04:44 PM
linking to contents of a cell vs cell address AinSF Excel Worksheet Functions 0 September 6th 06 06:57 PM
Return cell contents based on conditional lookup jarviscars Excel Worksheet Functions 15 August 5th 05 08:05 AM
Formula to return cell contents based on multiple conditions Bill Excel Worksheet Functions 3 January 19th 05 09:59 AM


All times are GMT +1. The time now is 10:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"