Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
return a cell address based on a matched value.. | Excel Discussion (Misc queries) | |||
Comparing cell contents, know cell address | Excel Discussion (Misc queries) | |||
linking to contents of a cell vs cell address | Excel Worksheet Functions | |||
Return cell contents based on conditional lookup | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions |