USING ADDRESS AND MATCH COMMANDS

[Tenspeed39355]

Hi Guys You sent me the Address and match commands, thanks. One question. At the end of the commands there are two numbers +2,4
=ADDRESS(2,MATCH(A2, A4:IV4,0)+2,4) By changing the numbers it changes the cell location. I am not sure what I am doing so could you please explain the 0, and the +2,4. Thanks for your time with this.
Max

[mdmackillop]

Hi Max,
The 0 says the match must be exact.
Match returns the order in the array where the match was found.
Because you are searching columns 4 to 256, the Match value returned will not equal the column number. +2 is a correcting factor based on your particular setup. This provides the column value for the Address function.
Address(2,x) will return the address of the cell in row 2, column x. The 4 says to return this in the E2 format, as opposed to $E$2.
Check the Help file for further info.
Regards
MD

[Tenspeed39355]

Thanks that helps me to understan the numbers. Good job
Max