Hi,
i am am trying to create a self populating document, but am struggling with a couple of lookups, I have about 4 different documents with around 20 tabs of info on each and tens of thousands of lines of data.
main issue I have is trying to get a vlookup to find two different cell values and then bring back one value across a different column;
i.e
A1 has to match b1, if b1 is correct to lookup c1, if correct then bring back value d1
if someone could help out would much appreciated!!
steve
i am am trying to create a self populating document, but am struggling with a couple of lookups, I have about 4 different documents with around 20 tabs of info on each and tens of thousands of lines of data.
main issue I have is trying to get a vlookup to find two different cell values and then bring back one value across a different column;
i.e
A1 has to match b1, if b1 is correct to lookup c1, if correct then bring back value d1
if someone could help out would much appreciated!!
steve