Re: Perform VLookup and Hlookup at the same time
Hello
Thanks for your help. Works perfectly.
Re: Perform VLookup and Hlookup at the same time
Hello
Thanks for your help. Works perfectly.
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
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
Re: If Formula correction
Thanks Wigi
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))
Your help will be appreciated.
Thanks
Paul
Re: Is the If formulae correct formulae to use.
Perfect. Thanks for your help it is much appreciated.
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.
Thanks for your support.
Paul Jones
Re: vlookup is this the correct function
Please find my workbook attached.
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
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
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
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
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
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.
Thanks for all your help.
Paul
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.
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.
Thanks in advance.
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
Re: Conditional Formatting.
Thanks for all your help it works perfectly.
Re: Conditional Formatting.
Hello Will
Can you please have a look at
http://www.llantwitmajorvale.co.uk/support02-02-06.xls
I have added a box explaining my Target.
Thanks
Paul
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.