Hi everybody... not very familiar with the syntax of formulas and arrays (the "ctrl+shift+enter" ones). Here's my problem.
Got a formula =MATCH($W2&X$1,$T$2:$T$620&$F$2:$F$620,0)... basically it combines the values in column W and row X (hence the ampersand) making it a uniqueID and looks such ID inside the combined values from columns T and F (again, I'm using the ampersand to match the ID). The output of this formula is meant to be copied in a range as an array (the "ctrl+shift+enter" stuff)
>> BTW, I found this in another post from "mmmarks"... kudos to him for the excellent idea!!
Here's my problem... how can I make the formula as an array (you know, F2 then ctrl+shift+enter) and still make the cells within the formulas as variables and changing according with the cells??
In other words, within the formula above the $w2&x$1 is meant to change from cell to cell once the array is complete however, everytime I copy the array formula it fixes the w and x to a single value throughout the whole array (and therefore, the formula gets funky)
Can you give me some light here?
thanks!!!
Bookmarks