hlookup / vlookup

Hi, I'm struggling with some formulas that use HLOOKUP to retrieve values from a table. I have checked that the reference values I give to HLOOKUP are correct, and that those values are present in the data table, but my formulas return #N/A even though everything seems to be correct. Context: I...

Hi I'm stuck on a spreadsheet on which I have managed to get VLOOKUP to work on one range. I'm made up that I've managed to get that to work but it's one basic piece of the jigsaw. I cannot get xl2bb to work either so cannot snapshot the spreadsheet. I want to be able to enter a weight in cell...

Hello, I have one column of data. What I'like to return is below. I'm not sure how to combine vlookup and hlookup or if even these are the formulas to use. Any help is appreciated. Desired result Lookup1 Virtual-abc Lookup2 Virtual-678 Lookup3 Virtual-lpo Sample data below...

Hi All, Thanks in advance for any help I am trying to use a HLookup to return data from a table of which the lookup value references a different cell which creates a value using a formula. My company working in "work weeks" so I am using a vlookup to use search for last weeks work week on our...

Currently fielding a question in a survey which allows free form responses of different brands, as a result there are a lot of misspellings and random responses. I am building a column list of these misspellings and random responses with the correct spellings/brand as a header of the column. I...

What I am hoping to do is actually more complicated than what I am currently asking. I am hoping I have simplified this enough so that it can make sense to someone who is not looking at the entire worksheet. Here is a screen shot of a portion of a single tab I want to refer to...

I have two tabs within my 2016 Excel workbook the first is called "Look up" and the second is "Return Value" . The formula I need would search the "Look up" Sheet and return "Test Preformed by" on the "Return Value" Sheet using the "Test ordered In" and "TEST #" as the criteria for the lookup...

I have the below data set and I need that information to complete the below table. The below data set is a small example, where you see Cat 1, Cat 2, etc - there are actually 30 of these. I need to fill in the below table, and need help creating the correct index, match or offset formula to...

Hi, I am looking to use a Index Match formula to look up data from a pivot table. I have most of the formula complete but I cannot figure out how to implement a match to pull data from my rows of my pivot. =INDEX('[2018 Pivot tables.xlsb]Pivot'!$C$11:$S$242,2,MATCH(B13,'[2018 Pivot...

Similar to the vlookup solution that does rows, I am interested to lookup rows and display as columns. (all matches) INPUT <tbody> StaffType StaffMember Manager Jane Worker John Worker Tom Manager **** Worker Harry Worker Bob Worker Joe </tbody> DESIRED OUTPUT <tbody>...

Hi all, i need some help with creating a dashboard of results and i don't know how to do it. Basically, i have a input of data sheet that looks like this, only more data: <colgroup><col><col span="2"></colgroup><tbody> The YTD Savings is based on a sumif statement adding each month past. Data...

Hi all, I am trying to create a formula that will automatically pull someone's name from a list depending on what code is listed under a specific day. The catch is the formula result has to be consider the day of the week and the time of day (AM or PM) that is selected in another cell. For...

Hi Experts, I found myself in a situation, I Have two Sheets Data in Horizontally and want fetch some details from them vertically as following: Sheet 1 <tbody> Vauxhall Ford Hall Gearbox 500 450 600 Engine 1000 1200 800 Steering 250 350 275 Ignition 50 70 45 CYHead 300 290 310...

Hi, ino sheet1 I have table: Into sheet2 I have other table: How to write a function, that will be automaticly taken value from sheet1 and put into col H - Target, to sheet2?

Hi, I am trying to extract certain text from a cell, I hope you can help. <tbody> (AAA)Which system use on {AAA}? 111 1 (BBB) Which system use on {BBB}?222 1 (CCC) Which system use on {CCC}?111 1 (AAA) What type of expenses processed through system? {AAA}-Rent 1 (BBB)What type of...

Hi wonder if anyone can help me, I am doing a datasheet where I am looking for information from a main data sheet to report onto a front page sheet. Tab 1 is my main sheet where the info will be displayed 1st drop down box selects the tab to gather info from 2nd drop down box selects the area...

Hi all, so here's my issue.. I need to pull certain values from a single column. The column is formatted so that Product ID's are typically on the top row and the UPC is located on the row directly below (not all Product ID's have UPC codes below them but I need to grab all the ones that do)...

Looking at this image: View image: ex 4 I want to be able to in cell C2 have a function that looks at Cell B2 and if it says "Yes" look at Cell B1 and it it reads "No" return value A1. For cell C3, what should happen is that it looks at B3 sees "Yes", then looks at cell B2 sees another "Yes"...

I want to reference one spreadsheet's data on another sheet. In the first sheet containing all the data, I have months in ROW 1 January-December. In rows 4-8, I have values according to different variables. It looks somewhat like this: <tbody> Month Jan Jan Mar Mar Mar Apr May Date 1/7 1/28...

I am having trouble searching a range containing workday dates for the closest one to the target. Ie. Jan 26, 2014 is on a Sunday, if this is the start date of a project I want the function to output Jan 24,2014. (This function is triggered by another sub, so I'm not really using it to output...