Posts by jonespa10

• Perform VLookup and Hlookup at the same time

Re: Perform VLookup and Hlookup at the same time

Hello
Thanks for your help. Works perfectly.

• Perform VLookup and Hlookup at the same time

Hi
I was wondering is it possible to perform a VLOOKUP AND HLOOKUP in the same formulae or is there another way to perform this task.

Can you please have a look at the attached example and hopefully this will become clear.

Thanks

Paul Jones

• Open File at a specific time everyday.

Hello
I have a excel file which I currently open on a daily basis.

This file has many calculations included within it.

When the file is opened it automatically updates the data stored on the spreadsheets.

The file is then saved and closed.

Is there any way I can carry out this routine automatically?

Thanks for you help.

Paul Jones

• If Formula correction

Re: If Formula correction

Thanks Wigi

• If Formula correction

Hello
I'm are trying to create an If Formulae but the result I'm am obtaining is Incorrect. Can you please help me with the syntax.

Basically what I want to say is If D31 =1 and B31=TP3N or C31 = TP3N then perform a Look up.

=IF(D31=1,AND(B31="TP3N",C31="TP3N"),VLOOKUP(E:E,'Mount Data'!A:D,4,FALSE))

Thanks

Paul

• Is the If formulae correct formulae to use.

Re: Is the If formulae correct formulae to use.

Perfect. Thanks for your help it is much appreciated.

• Is the If formulae correct formulae to use.

Hi

I'm trying to create a If Formulae but it has more than 4 Conditions.

I'm currently tieing my several up in Knots.

Can you please let me know if I can use this function in this way.

Paul Jones

• vlookup is this the correct function

Re: vlookup is this the correct function

• vlookup is this the correct function

Re: vlookup is this the correct function

Hi
Thanks for your help. I have run into another problem I have added another entry to Page 1 (R112) and I have tried filtering this through to Sheet 3 but am unable.

Can you please have a look at:-

http://www.llantwitmajorvale.co.uk/21-02-06.xls

Thanks

Paul

• vlookup is this the correct function

Re: vlookup is this the correct function

Hello
Thanks for the quick response, but I can't see any changes. Can you please check that you have attached the updated file.

Thanks

Paul

• vlookup is this the correct function

Re: vlookup is this the correct function

Hi
Thanks for all your help with this problem of mine.

Can you please refer to this attachement with my next problem.

This is all way above me. Can you recommend how I can improve my skills in this field?

Can you recommend any books?

Thanks

Paul

• vlookup is this the correct function

Re: vlookup is this the correct function

Hello Will
Thanks for all your help so far. I'm still having problems. When i apply this formulae to worksheet 3 it says

"You've entered to few arguments for this function.

I have tried everything I can think of but still can't fix it.

Thanks

Paul

• vlookup is this the correct function

Re: vlookup is this the correct function

Hi Guys
I'm sorry for this. I'm not sure if I am being stupid but I can't seem to get this formulae working correctly.

Any further help will be appreciated.

I have attached the file I am working on.

Thanks

Paul

• vlookup is this the correct function

Re: vlookup is this the correct function

Thanks Guys,
I am still having problems with this can you please have a look at the attachment not sure if I have applied the formulae correct.

Paul

• vlookup is this the correct function

Re: vlookup is this the correct function

Thanks for your help. I don't think I made myself clear in the first posting. Can you please have a look at this attachment.

• vlookup is this the correct function

Hello
I wonder if you can help me. I have some data in Worksheet 1 which I need to compare with worksheet 2 and then place results into worksheet 3.
I'm not sure if I am using the correct function to perform this task I have tried VLookup but it only shows the 1st Instance. Please can you open the attachment and hopefully it will be clear.

• Daily scheduling of a macro

Re: Daily scheduling of a macro

Hello
I have an excel document which will be left on Continuously and within this worksheet I need to run a Macro on a daily basis. If you can help me with the code I would appreciate it.

Thank You

• Conditional Formatting.

Re: Conditional Formatting.

Thanks for all your help it works perfectly.

• Conditional Formatting.

Re: Conditional Formatting.

Hello Will
Can you please have a look at the attachment and maybe it will be clearer what I'm trying to do. Thanks for your help it is much appreciated.