vlook up

So I have 2 workbooks, the first workbook contains a unique ID in a column as well as columns with name, age, skill level, skill name, expiry date in accordance to the unique ID. **NOTE: 1 Unique IDs may have 1 or more skill levels and skill names, different skill level = different row, same...

I have some sets in different sheets. I want to use the match function to be able to use the different names of those sheets by dragging down my formula.

I am in need of a formula which will search for a specific value in a column of cells that may contain more than one value in each cell. e.g. A B C D E F 1 ROLE RESULT ROLE RESULT 2 897 BONUS 563, 897 BONUS 3 167 #N/A 4 897 BONUS 5 637, 598, 897 BONUS 6...

Hi! Wishing you all a Happy New Year! This new year- My goal for this year is to ask for help and to understand macros and formulas more but since my workbooks seem a little tedious. I wanted to reach out because I have this extensive workbook with multiple formulas but I'm sure there is a...

Hello, I need help, If I want to use vlookup but want to retrieve all the data if there is the same data, for example like the following example. If I use the regular vlookup formula it will only take the number "1" but I want to take the numbers "1" and "2" as in column D. Is there a formula...

Hi. I have a macro that looks at a cell for a name, references another sheet and gets the email that corresponds to the name, and sends an email. I hopped into VBA and thought I entered the correct data to expand my vLookup. The original expression is: Recipient =...

Hello All, I'm looking for opinion for certain task which I need to execute in this table. If you think that can be done with macro or formula. What would be the best possible way. Header2 and Header3 are on different sheet, but that can be adjusted. ABCDEFG1Header1Output which I'm looking...

Hello Gurus, I'm currently have below code DATA 1 Sheet: ITEM 1 ITEM 2 ITEM 3 ITEM 4 DATA 4 001 002 003 Note: In cell E1, that is the Sheet where the data should be look up. Usually, manually filled as there are too many data sheet tabs. In the code below, it...

I want to sum if certain cells if the corresponding cell is marked with "Y" and if they are marked with "N" or left blank then subtract the amount in the corresponding cell. I am sure this is not hard to write a formula for but I cant figure out how to do it. Any help would be appreciated!

Hello! I have a data where I was success in filtering 2 column which do not include zeros, however, I was not able to retrieve the data which is related to those two columns. This My Table Table Slicers on Excel Dashboards DEPT Column1 Q1 Q2 BONE & JOINT CENTER left without being seen...

Hi There, (Columns A,B,C below) I need to Vlookup the Column C Value to see if its in Column B. IF it is return the Value in Column A. (This result would be inputted into Column D hopefully) 1234 Frank@gmail.com Susan@gmail.com 567474 michael@gmail.com Jimmy@gmail.com 47474...

Hi Everyone, I'd like to turn an iferror index match formula for one column and a if(change(vlookup in my second column, into just one column. How would I go about do this? My formulas are: This works for finding out new loans by index matching the type to with the current Join concatenate...

Hi there, I am working on creating Excel documents that function as multiple forms going to different people. So the idea is the first sheet in the workbook is the 'Mastersheet' with all of the data arranged in a table. Subsequent sheets contain the forms. Each form contains formulas that...

Hi, I want to look up a number that is in column D from column E, and if it is found in a table on a different tab in column A rows 9-109 put the work 'Expenditure' in the lookup cell in column E, and if the number found from the lookup is in column A rows 121-160, put 'Income' in the lookup...

Hi sorry for the question but I have been unable to find a clear answer..... Is it ok to use a partial selection of a spreadsheet for a vlookup for example the spreadsheet is 20 columns long the data your matching against is column 5 and the info you want to pull is column 11 is it ok to...

I am trying to loop find tomorrows date in Column H in file "dummy.xls" and every time it finds that date; then copy all the data in that Row into file "final.xls".

I have a set of data (see picture attached), where different projects have several dates, even within same month (A3:B16). My goal is to build a ''calendar'' that will show Projects and their first date that will fit within the selected month. E.g. in the picture: I want to see the projects...

I'm trying to do a vlookup (or an index/match if those functions are better suited), to find values based on the matching date, as well as 2 headers on a single column, and then I need to sum the returned values. The challenge I'm running into, is that I need to pull the data that matches the...

Hello, I need help, if I have a case to do a vlookup with 2 categories so that if criteria one is not found then it will be searched for with criteria two. I want to find "price" with the first criteria "code", if can't find it then look for the second criterion "product". Please help, what is...

I have a computer generated list of skills for 60 candidates. The goal is to build a table that tallys the skills across all candidates to determine which skills are most frequest there most important. However the list of skills I have for each candidate is messy. For example, Candidate A...