QUESTION with Match command and OFFSET

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?,

You can use the match within an INDEX function

--
Don Guillett
SalesAid Software
donaldb@281.com
"alomega" <alomega@discussions.microsoft.com> wrote in message
news:0FD9F610-07DF-4612-806A-B1B6A6F59C6E@microsoft.com...
> 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?,

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

"alomega" wrote:

> 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?,