Excel - misbehaving VLOOKUP

  daba 12:15 28 Dec 2008
Locked

I have a VLOOKUP in cell C3 that is not returning the correct result for the first row in the lookup range. The file is here :-

click here

and is in Excel 97 format

Can anyone please shed some light on the problem.

  daba 12:31 28 Dec 2008

It's OK folks - I['ve found the problem, I had omitted the True/False spec in the VLOOKUP argumets.

All is sorted now thanks anyway

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?