to debug this, I would use the match() function to see what line is being
found in both sections.
=match(F252,'YB Engineer planning'!G:G)
=match(F252,'YB Engineer planning'!A:A)
check over the appropriate number of columns and see what you get.

"beautyteknorth" wrote:


Please help!

=IF(VLOOKUP(F252,'YB Engineer planning'!G:H,2,FALSE)="Olivetti
Decommissioning",VLOOKUP(F252,'YB Engineer planning'!A:H,3,FALSE),"")

I am trying to lookup two lots of data - one is a filter - "Olivetti
Decommissioning" - then the site name is the second lookup provided the
work is "Olivetti Decommissioning".

The formula above works perfectly well for 95% of my data but for
reasons best known to someone else there are 5 lookup entries that
result in a blank cell (which is stated in the formula if there are no
entries for the site name and "Olivetti Decommissioning"). These 5
entries ARE available on the Engineer planning worksheet. Most of the
entries have more than one entry on the Engineer planning sheet but it
is just the five that are not getting a result. I know that the formula
is referencing properly because I get an #N/A if I change the names
slightly.

I have ensured that the lookup data is spelt the same. I cannot see
what the issue is? Any ideas? Thanks in advance!



Amanda


--
beautyteknorth
------------------------------------------------------------------------
beautyteknorth's Profile: http://www.excelforum.com/member.php...o&userid=37585
View this thread: http://www.excelforum.com/showthread...hreadid=572113