vlookup & hlookup

Hello, as per the below, i have a sheet showing a page of info about different people. On a second sheet i have a list of the people: Person1, Person 2 etc and want to be able to quickly pull through the "Actual" result. Is there a way to lookup (for example) "person 6" across multiple columns...

Hi, I'm trying to implement automation in my office attendance workbook and for that i've written this code in between 2 sample sheets, attached are the 2 sheets in which i'm trying to take value from RAW_Data Sample Sheet from unique HRMS Id column and match that with Shrinkage_Sample Sheet...

I am trying to sum up stock that was received in a given month to each individual location. I can't do a vlookup because the same item might hit multiple locations and not give me the correct quantity received in at that location. I have two separate worksheets. One worksheet is a summary of...

I have two sheets: the first with data with column headers as 'Line#s' I need to change based off of a lookup table on the second sheet. Both tables have an overall category (ID) and sub-category (Type). The header names in the lookup table vary depending both categories. I need a condition...

In ColumnA I have sentences wrapped and in columnB list of words formula should lookup range of words in columnA and get 4 words including matched word. for example. Robert is honored in computer science and Robert earned GPA 3.6 and he has a bachelors degree (ColumnA) 3.5 (ColumnB Range) 3.6...

I have a multi-sheet workbook which has some sheets called Week1 Week2 etc. I also have a sheet with a range of dates in column AB4 to AB35 In the worksheet Week1 etc, I have dates stored in row B5 to H5. I have a named range called "SheetList" which contains the names of the worksheets Week1...

I'm working to get an index match formula to find a value in one table based on criteria in another. An example of each table is below, with my desired output being in the "Price" column of Table 1. Table 1: <tbody> Column A Column B Column C Column D Row 1 Thickness Type Width Price Row...

Hello, I am trying to lookup a data from table 1 to table 2 however, the vlookup is not matching locations and picking up the first role it finds: See below: Column A Column B Column C Column D Column E Column F Column G Column H <colgroup><col><col><col><col><col...

Hello, I need to fill in a table by matching the vertical number in Column J with the horizontal number in Row 3 and then entering a 1 if they match or blank if they do not match. I've added a 1 at the intersection of N4 because both the vertical and horizontal numbers are 31494. Table looks...

I have searched the forum for a suitable technique to solve this problem and I can find nothing that helps. I have a spreadsheet that tracks a large number of staff and changes to staff status. worksheet 1 contains the core data and tracks changes on a week-by-week basis (each week starting...

I am trying to determine if certain we a purchase a particular stock occurred between multiple time periods- see pic, but in short I want to search Column L for B2, and check if the date in A2 falls between any of the date ranges for the occurrences of B2. Sorry for the illustration I couldn't...

Hi all - I'm new here and really hoping that someone can help me before I pull all my hair out! This is a sample of the data I have. I have over 24k rows that look just like this. <tbody> Group ID Merge Key Master Record Exclude Record Record ID Key Indicator Constituent Import ID G-1...

Hello, I need to do a Vlookup using criteria from the columns and rows. For example: <tbody> ID/CLASS APPLE BOY CAT DOG EGG FAN GUN HORN INK 1243 5,600 765 1,123 1445 2,434 112 445 9,400 2,454 3243 3,001 223 7,210 222 30 2112 3,233 211 448 101 2,444 6756 9,312...

I am attempting to match data (state and year) in two tables that have the same h row and v column headers by using 2 drop list <tbody> State Year Population Cases Drop List Drop List Result From Table 1 Result From Table 2 </tbody> Both tables would look similar to the following: Table 1...

I am attempting to match data (state and year) in two tables that have the same h row and v column headers by using 2 drop list State Year Population Cases Drop List Drop List Result From Table 1 Result From Table 2 Both tables would look similar to the following: Table 1 (Population)...

Hello All, Thank you for your time. I am in need of your assistance in finding a better way, a more efficient non-vba way, of getting the results I get from nesting Ifs. I currently pull data from our main frame and do a visual scan. I developed a crude If statement...

I’m looking to create a formula that will look at two separate columns [Status] and [Quarter] and select (for example) HP in column F and Q1 in column. Then add all those particular numbers located in the G column and add them. Example would be an outcome of all numbers added would have both...

Help Required My problem is i want to past the complete cell of that particular teacher with (subject, name of that teacher & Class) in there receptive ROW, it will help me to know which subject & Teacher and which class that particular teacher is teaching in "Sheet 1" i have highlighted...

I'm new to coding VBA and have coded a good amount of what I'm trying to do, but there are a few things I'm having problems with coding. I think I might be able to figure out a few of the other issues I'm having with my code if I can first figure out how to loop through a vlookup to complete...

Is it possible to run a VLOOKUP or other formula to compare two worksheets, then if Cell A is present in both of them return the whole row on a third sheet? Is this possible?