QUESTION with Match command and OFFSET

[Guest]

I want to use the Match command with "0" as match type. The Match command
returns a value of the row that was found from the Match command.

The problem is how do I add the text string located in a specifc column
located on the same row, as referenced by the Match command to be included
after the row reference indicated by the Match command?,

 

[Don Guillett]

You can use the match within an INDEX function

 

[Guest]

Hi,
Seems to me that what you describe is the VLOOKUP function with False option.
Eg: Search A1:A100 for "hello" and display the corresponding value in
column. D
=VLOOKUP("hello", $A$1:$G:100, 4, FALSE)
"hello": value to search for.
False : means exact match (similar to 0 with MATCH
4: column number within $A$1:$G:100 to be returned
$A$1:$G:100: data range. VLOOKUP only searches the first column for a
match. Note: that the range must include the column to be reurned (here,
column 4 ie D)
If no match found, it returns error #N/A

Regards,
Sebastien