Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi All,
is it possible to create a function that will look for a text/value in a table and return the cell reference? I only have dierent values in the table, no value repeats. For Example: table A1:C3 aaa bbb ccc abb abc acb baa bba bbc in another cell (J2) I have the value "abc" and I want a formula to return the cell reference in the spreadsheet nest to it. I don't want the "abc" in the formula because I want to find different values. function(J2) returns the cell reference in the spreadsheet, B2. Thanks a lot for the help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP CONDITION TO RETURN BLANK CELL WHERE LOOKUP VALUE IS NOT IN TABLE ARRAY | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
return cell reference from any column | Excel Worksheet Functions | |||
Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions |