Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get cell address from Lookup function results
Hi Guis,
I have a spreadsheet to copy data into specific columns. I was heading to use the lookup functions in order to identify de destination cell address but I cannot convert the lookup results into a cell reference. Is there any way of doing that? Or else, how can I perform a search to identify the correct destination cell address? Thanks in advance Felipe |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get cell address from Lookup function results
Hello Felipe
Use MATCH instead for example : =MATCH(B1,A1:A500,0) Where B1 is the criteria you're looking for And A1:A500 is the range where stands your data. This will return the position number where the value will be found. It will then be easily adapted to return a cell address with the ADDRESS function, for example: =ADDRESS(MATCH(B1,A1:A500,0),1) This will return an absolute range address If you wish to return a relative cell address, use: =ADDRESS(MATCH(B1,A1:A500,0),1,4) See help on both these functions. HTH Cordially Pascal "Felipe Accioly" a écrit dans le message de news: ... Hi Guis, I have a spreadsheet to copy data into specific columns. I was heading to use the lookup functions in order to identify de destination cell address but I cannot convert the lookup results into a cell reference. Is there any way of doing that? Or else, how can I perform a search to identify the correct destination cell address? Thanks in advance Felipe |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Invalid LOOKUP Function Results | Excel Worksheet Functions | |||
Using a lookup function to output a cell address | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
look up a value that results in a cell address | New Users to Excel | |||
Using the results of CELL function ("address" info type) | Excel Programming |