lookup

Hi After some help on a formula please which will make life so much easier. What I am after is when a word is put into 1 column it will use this then to add 1 hour onto the hours on the same row. Example below of table. Basically when AL example is entered into Column F2 it then takes...

I have a repetitive task daily that could go away with the help of VBA. I have a sheet that lists a large group of retail stores. In column "U" of the sheet "Future_Launch_Locations" it has the state that the store is in. In column "N" I need to fill out an HVAC Provider. A second sheet...

i am using this formula using lookup =LOOKUP(2,1/(HHPPD[Code]=[@Code])/(HHPPD[SD]<=[@DOS])/(HHPPD[ED]>=[@DOS]),HHPPD[NP]) i want to use index match to rewrite the formula, i am trying following formula but it is resulting in #NA, whereas above mentioned formula is resulting in right value...

Hi guys, In the last few days I've been doing an internal assessment of the skills needed by certain companies that we working for, but also the skills that my employees have. With that, I started to create a kind of database in which: the first sheet has the necessary technologies to ensure in...

Hello, Long time reader, first time poster. I have a large dataset of relationships between "C Items" and "R Items". For a given "C Item" I would like to return each associated unique "R Item" only one time. Some "C Items" may have only one "R Item" and others may have fifty. I've included...

Hi Friends, I need your help to lookup and find out a specific value from a list. I am using office 365 and below provided a sample data of my requirement. CategoryStatusCategoryResult for NewDataOldDataYesDataNewStyleNoDataExistingStyleExistingStyleOldStyleRejected I need to check whether...

Hello - looking for an Excel whizz. Trying to complete Cell J3 with a column header based on the player and their 'score' from the week. I have tried a combination of LOOKUP with INDEX MATCH but not quite getting it. Any help would be much appreciated. Many thanks!

Hi, I have two PowerPivot table that I want to combine and copy information to a third table, however the search criteria is empty as the two PowerPivot tables' amount of data changes from month to month. 1) I want the formula in column K for table 3 to be able to copy values from column B...

hi can anyone help me in following lookup value with multiple criteria, but i want with array plus, which is faster. array formula or vlookup? date code Rate 25-May-21 613974 0.376 24-Jun-21 613974 0.376 15-Sep-21 613974 0.376 20-Sep-21 613974 0.376 29-Oct-21 613974 0.39 21-Dec-21...

I have a worksheet that utilizes several functions to get data depending on other information. One “Category” inputs Mobile Phone based on the amount of a given month’s expense. This amount can vary as you can see by the attached Xl2bb. Is there some way whenever the monthly Mobile expense...

Hi everyone, Please see below sample data set. The columns are always going to be the same, but the rows will be dynamic each time a report is run. ABCDEFG1Start01-May2End07-May34NoNameDateCategoryTypeDrCr515Name101-MayEntertainment-200690Name201-MaySupplies1500745Name301-MayTravel...

Hi Hopeing someone can help. I am trying to get a closet value in a table into another cell. Example is Selling Apples. We sell apples in Packs of 2,4,6 We sell the pack sizes of apples in QTY of 10,20,30,40. I am trying bring in the closet value if someone chooses a QTY of 23. Excel would...

Hi, I am trying to make a column to obtain last values that were added in some table. Each month table expands so new values are added... So far, I managed to get the way to obtain last value, last value -1 and last value -2 (so I'm having last 3 values in other words). My problem comes when...

I need a formula that will place a text string in a row specified by the number from an adjacent column within a look-up table. Additionally, I also need a formula that will return a text string based on the same row number described above, plus a match of the ID number with the same ID #...

I want to be able to drop information into sheet 1, and automatically in sheet 2 it searches for the column name and inputs the data below that? In more detail, I want to be able to drop multiple different invoices into sheet 1, the problem is they are never laid out the same. I'm hoping to...

I have a sheet - daily routine which has two columns: activity and time as shown here | Activity | Time | |----------------------|----------| | Sleep ? | 6:00 am | | Toilet ? | 6:15 am | | Get ready for gym ?‍♂️ | 6:30 am | | Exercise ? |...

Hi all, I currently have the following setup: I have some numbers in column C and D, and I use a simple sum() formula in column B. However, I also want to be able to click on the cells in column B and see the value in the formula bar. But I want to keep the formulas in the meantime. What I...

Hi, I'm struggling to find the way in how to use xlookup function, to obtain data from another workbook, but without using the workbook name/path. I want to avoid using the name of the workbook and the path, because its going to be changing each day both name and location, earlier in the macro...

Hi All, I'm wanting a function to look down a list and based on certain required criteria on that lookup, return all values in a list format starting in a specified cell. So as below let's call this range A1:D5. I want the lookup to look down Column A:A searching for "Graham" and then in C1...

Hello, I am looking for a particular function or set of functions that will allow me to display data on a "summary" tab in excel. The context for the data that I am dealing with is listed below: I have multiple values from different regions that differ each month, what I would like to do is...