Thanks for that. The link doesn't work by the way. I think it is because it is a HTTPS. But thanks for the reply,
Thanks for the article. I have used LOOKUP a lot over the years but never VLOOKUP. It makes things a great deal easier for complex analysis. Just one query - can the column number be a variable?
I started using spreadsheets on the early 1980's. There was a brilliant programme who's name I can't remember. In many ways it's functionality was way ahead of Lotus and Excel when they came out, and in many ways more user friendly then Excel/Word now. It was a truely integrated spreadsheet, word processor and database. I used to prepare clients accounts and tax comp's on it. The great thing was you could use the spreadsheet in the middle of a word processor document but, unlike embedding Excel into Word, it was totally seamless and then you could mail merge names/addresses etc from the database.
One of the first novel uses I put it to was when I was working for a professional footbal club and I had the league set up so that as results came in you could see how it affected the positions in the table. This was great mid match and towards the end of the season as you could keep on updating it during play. Very basic now of course but in those days it would be quite some time before the league tables were worked out at the end of the day and available on the TV (all the matches were played on Saturday, or mid-week, at the same time).
In many ways we haven't come very far in those almost 30yrs.
-- OrigamiGroup.co.uk - Business Support from accounts to strategic planning