Re: Embedded VLOOKUP function within IF function
 From: Dav <Dav.2coe8e_1155803799.2423@xxxxxxxxxxxxxxxxxxxxx>
 Date: Thu, 17 Aug 2006 04:31:25 0400
If you are using a match type 0, which is the same as your vlookup in
essence it will always return the first match.
You maybe have to restate your problem giving an example and showing
what you want exactly as the solution. In your example
=IF(VLOOKUP(F252,'YB Engineer planning'!G:H,2,FALSE)="Olivetti
Decommissioning",VLOOKUP(F252,'YB Engineer planning'!A:H,3,FALSE),"")
If the first match of f252 in columnG has olivetti Decommissioning next
to it you are then saying rematch this value in f252 in columnA and
return the value in column c next to it.
If column A is different to column G you will not be returning the same
row
What exactly do you want to achieve?
Regards
Dav

Dav

Dav's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27107
View this thread: http://www.excelforum.com/showthread.php?threadid=572113
.
 References:
 Embedded VLOOKUP function within IF function
 From: beautyteknorth
 Re: Embedded VLOOKUP function within IF function
 From: beautyteknorth
 Re: Embedded VLOOKUP function within IF function
 From: Dav
 Re: Embedded VLOOKUP function within IF function
 From: beautyteknorth
 Embedded VLOOKUP function within IF function
 Prev by Date: Average & median of text "time" numbers
 Next by Date: Re: Average & median of text "time" numbers
 Previous by thread: Re: Embedded VLOOKUP function within IF function
 Next by thread: Vlookup value between 2 cells
 Index(es):
Relevant Pages
