| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup to return the cell positioning where the criteria is found
-- Thanks Roch |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vlookup to return the cell positioning where the criteria is found
use the match function.
-- Regards, Tom Ogilvy "Rock" wrote in message ... -- Thanks Roch |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vlookup to return the cell positioning where the criteria is found
Hi Rock
=CELL("address",INDEX(A1:B200,MATCH(C1,A1:A200,0), 2)) where your lookup_value is in C1, the table_array is A1:B200 and the information you want returned is in column B (ie your vlookup statement would currently look like =VLOOKUP(C1,A1:B200,2,0) Cheers JulieD "Rock" wrote in message ... -- Thanks Roch |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return all values found for criteria | Excel Discussion (Misc queries) | |||
| Vlookup, return zero if not found | Excel Worksheet Functions | |||
| Change the appearance cell where Find criteria is found in a cell | Excel Discussion (Misc queries) | |||
| Return a value if criteria contained in cell | Excel Discussion (Misc queries) | |||
| Formula to return ADDRESS of cell in range that meets criteria | Excel Worksheet Functions | |||
Linear Mode
