Blogger
Share this content
0
1
1704

adding like items in worksheets (2)

Thanks to David and Richard for your earlier advise and answers to my original query.

Unfortunately, I am a real +1+2+3 excel student.

David - could you please explain how to use vlookup? I have looked at the help in excel but fail to understand how to apply it.

Richard

Once again, I have tried the formulae and looked at excel help, but am still confused. Do I press ctrl+shift+enter sfter I have typed out the formule, then excel will insert {}, or do I press ctrl+shift+enter when they are required in the formulae?

Is there a quick way of getting excel to recongnise all the worksheet in the formulae without having to manually input the worksheet names?

In your last example, what does G1:G3 represent? Are they worksheets names G1 through to G3?

Sorry for being thick. Again. I do try but struggle sometimes.

Thank again in anticipation.
Alan Wilson

Replies

Please login or register to join the discussion.

avatar
07th Nov 2007 15:08

send us a sample
Alan, it's always a lot easier to understand the problem if we can actually see the data.

Any chance of sending me a sample? Obviously, change any sensitive information. Address david(dot)carter(at)moose(dot)co(dot)uk

Thanks (0)