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


[TABLE="class: cms_table, width: 102"]
<tbody>[TR]
[TD]BRL[/TD]
[/TR]
[TR]
[TD]09.01.2010[/TD]
[/TR]
[TR]
[TD]02.02.2010[/TD]
[/TR]
[TR]
[TD]14.02.2010[/TD]
[/TR]
[TR]
[TD]16.02.2010[/TD]
[/TR]
[TR]
[TD]17.03.2010[/TD]
[/TR]
[TR]
[TD]04.04.2010[/TD]
[/TR]
[TR]
[TD]07.04.2010[/TD]
[/TR]
[TR]
[TD]19.04.2010[/TD]
[/TR]
</tbody>[/TABLE]

 

[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).