Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup, and Return Cell Address
I have a follow-up question for T Valko.
Can you offer some kind of modification, or alternative, to the second function (below) that you gave me yesterday? In the form that you gave all functions to me, all functions worked great! However, I made some modifications, and now I have a problem here. I used your first function, and ended up counting the number of matches, between items in my Column A on the active sheet, and items in Column A on the Import Sheet: =COUNT(SEARCH($A7,'Import Sheet'!$A$1:$A$65000)) CSE, of course. This function is in my Column B of the active sheet, and this works fine. Then, I used your second function, and found all cell addresses on the Import Sheet, which is what I wanted: =IF(ROWS(C2:C$2)<=B2,"A"&SMALL(IF(ISNUMBER(SEARCH( A2,'Import Sheet'!A$1:A$65000)),ROW('Import Sheet'!A$1:A$65000)),ROWS(C2:C$2)),"") This function is in my Column C. Finally, I used your third function: =INDIRECT("'Import Sheet'!"&E2) This function is in my Column D. I then inserted rows in Column A, sort of as place holders, for each of the numbers which are in Column B of the active sheet. This allowed me to show each of the cell addresses (Column C of my active sheet) and each bit of text from these cell addresses (Column D of my active sheet). So, I thought everything was going to be roses, but then I realized the second function stops counting when I inserted those rows in my Column A! Do you have any idea what could be causing this? Does anyone have an alternative to look up cell addresses, such as Address & Vlookup? Tried a few combinations of things and nothing seemed to work¦¦¦¦. Cordially, Ryan--- -- RyGuy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
USING VLOOKUP TO RETURN A CELL ADDRESS | Excel Worksheet Functions | |||
LOOKUP & RETURN CELL ADDRESS | Excel Worksheet Functions | |||
V Lookup and return cell address | Excel Worksheet Functions | |||
How do I return the cell address of the largest of a set of values | Excel Discussion (Misc queries) | |||
How do I use a function to return the address of a cell? | Excel Worksheet Functions |