Vlookup using 1 value & 1 text data if both true returning the value data
- Thread starter shaggy72
- Start date
NARAYANK991
Excel Ninja
Hi ,
I am not sure what you want to do.
A VLOOKUP function , with the range ( the second parameter ) being a single column range , means the third parameter , the column from which a value is to be returned , can only be 1 ; together , these will return the following :
1. Where the looked up value ( the first parameter ) exists in the lookup range , it will return the looked up value itself
2. Where the looked up value does not exist , it will return the #N/A error value.
Since both your VLOOKUP functions are in the same style , all that the two functions will do is either return MASTER!D4 , C3 or the #N/A error value.
Is this what you want to do ?
If so , then when you combine the two formulae in one , what should be returned if the combination exists ?
Narayan
I am not sure what you want to do.
A VLOOKUP function , with the range ( the second parameter ) being a single column range , means the third parameter , the column from which a value is to be returned , can only be 1 ; together , these will return the following :
1. Where the looked up value ( the first parameter ) exists in the lookup range , it will return the looked up value itself
2. Where the looked up value does not exist , it will return the #N/A error value.
Since both your VLOOKUP functions are in the same style , all that the two functions will do is either return MASTER!D4 , C3 or the #N/A error value.
Is this what you want to do ?
If so , then when you combine the two formulae in one , what should be returned if the combination exists ?
Narayan
Hi Narayan ,
Rule 1 - look =VLOOKUP(MASTER!D4,’VDQ Monday’!A2:A166,1,0) this returns payroll number 914
Rule 2 - =VLOOKUP(C3,’VDQ Monday’!D2:D166,1,0) this returns Name "RKD Sprout Peeler"
RULE 3 - If rule 1 is true (payroll 914) and rule 2 is true ( Name "RKD Sprout Peeler") please return the rule 1 ( payroll number 914) if not return blank.
if not true (false) return blank.
Hope this helps
Rule 1 - look =VLOOKUP(MASTER!D4,’VDQ Monday’!A2:A166,1,0) this returns payroll number 914
Rule 2 - =VLOOKUP(C3,’VDQ Monday’!D2:D166,1,0) this returns Name "RKD Sprout Peeler"
RULE 3 - If rule 1 is true (payroll 914) and rule 2 is true ( Name "RKD Sprout Peeler") please return the rule 1 ( payroll number 914) if not return blank.
if not true (false) return blank.
Hope this helps