lookup

Hello, I have tried VLOOKUP, HLOOKUP, and too many others to list. I think it will be easier to show: So, I have a spread sheet with several different hardware and hundreds of serial numbers. i would like to type in the serial number and see the hardware displayed.

Hi there, I was wondering if would be possible to use a cell with comma-separated values that have suffixes (i.e. iterations or repetitions) that in turn translate into the full value in the lookup table. The dataset we use is frankly ugly, but it would be nice if there was a way to make the...

Hi There, I'm trying to get data ready to move from Excel into a database & I have thousands of rows/columns like the following. For each unique RequestID, I need to return the Year the transaction occurred. Appreciate any guidance!

Hello, I have 4 sheets in a workbook (Sheet1, Sheet2, Sheet3 and Sheet4) On Sheet1 I have a dropdown in B1 to select from a list of fruits. For eg. Apple, Banana, Cantaloupe, Below that dropdown there is a "Store" table with headers Store(A5), Isle(B5), Shelf(C5) On sheets 2,3 and 4, I have...

I have a few items for lookup defined in a range, e.g. Col A is the name and B is the Category. Biscuit Snack Sandwich Snack Milk Beverage Potato Vegetable In another sheet, I have column A with free form text which may have a mention of the words listed above. The text cannot have...

Hello excel experts, I want to grab a list of unit numbers based on criteria in another column. If a row in column G contains "Tax Credit", return the corresponding row value in column B. There is a formula that accomplishes this task: =INDEX(Sheet1!$B$8:$B$86,SMALL(IF("Tax...

Using google sheets, is there a way to look up a value on the vertical & horizontal axes between two numbers? If years of service is 2.8 and company growth is 18.8, how can a lookup formula return 10%? We are rounding down on both years of service & company growth. Company growth: greater...

Hi, Hopefully someone can help. I require a formula in Sheet 1, A1 to search for text contained within Sheet 1, A2. The formula will need to see if the text appears in Sheet 2, C1 to C999 for which it will return the text "NI", or Sheet 3, C1 to C999 for which it will return the text "ROI"...

Hi, I'm trying to find a formula that will help with the below conundrum (sorry for not using the XL2BB, but I don't have permission to download on my work laptop). Basically, The criteria can be found in cell B7, B8 and B9 and the correct result of 3 has been returned in cell B10. What this...

Hi all, I currently have a data set that looks like this: I would like to transpose my information down under columns H-L so that for ALL cells in A that contains "George", their respective cells in columns B-F will be transposed under column H. Likewise the same for all cells that contain...

I have 2 sheets Export (Contains a table) Sheet4 (Contains a range of data) on Export I have an ID ref number in column D. This ID refers to a person on Sheet4 with multiple job start dates back on the Export tab, I also have a shift date in column M ([@Shift_Date]) I want to look...

Hi all, I currently have a large data set, it looks like this: I want to vlookup my data from column A-C into column J-L. However, as the names reappear and sometimes even share the same date (example in A4:B5) a vlookup won't be feasible. The dates are correct in my other table, as well as...

Good afternoon, Our biggest payroll client at our accounting firm has roughly 70 active employees whose payslips and benefits we calculate, and every month their representative asks for a salary map (Objective Table), which today I just learned is done by hand, meaning our accountants have to...

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!