Vlookup with and or if

[Vv3bby]

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

 

[AliGW]

You will need to use the AND function. Something like:

=IF(AND(A1=B1,C1=something),VLOOKUP(...),"")

 

[Vv3bby]

Thanks I'll give that a try when I get to the office in a few hours