# 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

- 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):