I have 2 vlookup functions that are totally separate but the selection of one
is affecting the other as though they are linked in some way. Func A returns
a blank cell until I make a selection in Func B which causes the correct
return to appear in both.When I clear the lookup value from one the result
disappears from both. Where could a link exist between the two. Both have
different linked cells and table data!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200910/1

I would suggest posting the formulas.

Quite possibly they are indeed linked by overlapping ranges or??


Gord Dibben MS Excel MVP

On Sat, 17 Oct 2009 06:24:07 GMT, "Bruister via OfficeKB.com" <u50445@uwe
wrote:

I have 2 vlookup functions that are totally separate but the selection of one
is affecting the other as though they are linked in some way. Func A returns
a blank cell until I make a selection in Func B which causes the correct
return to appear in both.When I clear the lookup value from one the result
disappears from both. Where could a link exist between the two. Both have
different linked cells and table data!