Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference Cell if Found in a IF function
I'm trying to setup an IF function so that it searches for a value, then if
Value is found (TRUE), to offset from the cell within which it was found. Ex: With the formula written into Sheet 2, B, I want it to search column A of Sheet 1 for a 22, then if found offset from where it was found up one cell and report the station name. Sheet 1 Sheet 2 A A B Station Name 22 Station Name(variable) 22 (variable) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference Cell if Found in a IF function
Formatting came out funny in my example. Hope the text is clear enough...
if more is needed let me know and I'll try to explain further. "A Stevens" wrote: I'm trying to setup an IF function so that it searches for a value, then if Value is found (TRUE), to offset from the cell within which it was found. Ex: With the formula written into Sheet 2, B, I want it to search column A of Sheet 1 for a 22, then if found offset from where it was found up one cell and report the station name. Sheet 1 Sheet 2 A A B Station Name 22 Station Name(variable) 22 (variable) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Reference Cell if Found in a IF function
With your datalist on Sheet1 in Column A,
Try this on Sheet2, in B1, with your value in A1: =INDEX(Sheet1!A1:A100,MATCH(A1,Sheet1!A1:A100,0)-1) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "A Stevens" wrote in message ... Formatting came out funny in my example. Hope the text is clear enough... if more is needed let me know and I'll try to explain further. "A Stevens" wrote: I'm trying to setup an IF function so that it searches for a value, then if Value is found (TRUE), to offset from the cell within which it was found. Ex: With the formula written into Sheet 2, B, I want it to search column A of Sheet 1 for a 22, then if found offset from where it was found up one cell and report the station name. Sheet 1 Sheet 2 A A B Station Name 22 Station Name(variable) 22 (variable) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you have fixed cell reference when dragging/copying formulae? | Excel Discussion (Misc queries) | |||
Getting contents of a cell when cell reference is in the sheet | Excel Discussion (Misc queries) | |||
copying the function contained within a cell to anouther cell. | Excel Worksheet Functions | |||
Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
how do I format a cell reference to move as source changes | Excel Worksheet Functions |