Macros VBA solution needed for IF

[shalomfern]

I want to refer to any date of the data set and make the cell value move UP until cell value is equal to text or in this case "BRL"

Because "BRL" is a Row label of a Pivot table and I want VLOOKUP to look at the code assigned for BRL.
If it is text, I want excel to run the formula in BLUE, otherwise I want excel to move up the column until it finds a text.

=IF(ISTEXT(A9); VLOOKUP('Transport Rates'!$A6; MDshowrooms!$C$5:$F$30; 4); OFFSET(A11; -1; 0; 1; 1))

but with this formular, it only moves once. it doesnt keep checking the new cell value.

I thought macros can help me to repeat but I seriously lack the coding knowledge. NEED HELP

BRL
09.01.2010
02.02.2010
14.02.2010
16.02.2010
17.03.2010
04.04.2010
07.04.2010
19.04.2010

<tbody>
</tbody>

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-...ion-loop-any-other-solutions.html#post4689031

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).