Forum

Hello, A simple solution is to create one extra column in both tables, then you can use VLOOKUP. Note: I hade both files opened when working wit...

Hello, Sorry, there is no file attached.

Hello, It would help a lot if you can provide some sample file or two. No need for real data, what is important here is to see the structure and wh...

Hello, Not sure if the example in the attached file is good enough, but it is at least simple and do show what you want to see. Br, Anders

Hello, Check these pages.

Hello, The formula Sunny provided is an array formula. Just press the control and shift keyes and then press enter. /Anders

Philip Treacy said Your data validation formula could be =EXACT(B2,VLOOKUP(B2,E2:E6,1)) with the cell you are typing into being B2 and the permitte...

Hi, You can get that using Pivot Table. See attached. Br, Anders

Hello, I don't see any query in your file, so below is the Excel formula I assume you want. =VLOOKUP(MROUND(I8,10),Table_Lookup,2,TRUE) Click re...

Hello Sunny, Unfortunately the TRIM() function in a data validation does not do the actual job on the cell content. If you type in a space as first...

Hello, This blog article gives a good answer on which Excel versions have PQ or not. Br, Anders

Hello Gayla, Well, it's true that the article did not give a specific answer on how to get what you want, but it surely gives some hints to get you...

Hello, There is a blog article written by Mynda that should help you forward. Check this out. Br, Anders

Hello, I agree with Frans and also, do consider take one or several great courses here at MOTH. I think the Excel course could be a good start. ...

Hello Tom, Just took a quick glimpse of your sample file. If you are able to get the hours data in a tabular format + in that data also have the em...