Vlookup with and or if

Vv3bby

New Member
Joined
May 7, 2014
Messages
2
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

.
Joined
Mar 9, 2014
Messages
3,628
You will need to use the AND function. Something like:

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

Vv3bby

New Member
Joined
May 7, 2014
Messages
2
Thanks I'll give that a try when I get to the office in a few hours :biggrin:
 

Forum statistics

Threads
1,086,235
Messages
5,388,624
Members
402,127
Latest member
Jemx

Some videos you may like

This Week's Hot Topics

Top