R
roniaelm
Hello,
I am creating a list where I want Vlookup to populate by returning
particular values from an Overview list. However, I want Vlookup, to
find (match) the values in two different cells before donig so:
e.g. My overview list contains the last names and first names in
seperate cells:
A B C
Smith John Red
Smith Tom Blue
I want Vlookup to lookup the values in cells A and B before giving me
the value in C.
I am using the following formula:
=IF((AND(A1=Overview!A1,B1=Overview!B1)),VLOOKUP($A:$A,Overview!$A:$C,
3,FALSE)," ")
However, the problem is, that the names can be anywhere in the
Overview list and therefore I cannot use absolute cell references.
E.g. Smith, John can be in cell A5 in the Overview list and not
necessarily A1.
Does anyone know, a better way of using this formula.
Thanks a ton!
I am creating a list where I want Vlookup to populate by returning
particular values from an Overview list. However, I want Vlookup, to
find (match) the values in two different cells before donig so:
e.g. My overview list contains the last names and first names in
seperate cells:
A B C
Smith John Red
Smith Tom Blue
I want Vlookup to lookup the values in cells A and B before giving me
the value in C.
I am using the following formula:
=IF((AND(A1=Overview!A1,B1=Overview!B1)),VLOOKUP($A:$A,Overview!$A:$C,
3,FALSE)," ")
However, the problem is, that the names can be anywhere in the
Overview list and therefore I cannot use absolute cell references.
E.g. Smith, John can be in cell A5 in the Overview list and not
necessarily A1.
Does anyone know, a better way of using this formula.
Thanks a ton!