vlook up

  1. J

    Vlookup into next blank column

    Hi everyone, I'm an excel newbie and trying to figure out how to make something work in VBA. Y'all seem like a really nice bunch, so I'm hoping you can help me out! I've managed to automatically create a pivot table containing days worked per week per person from a raw data file and would like...
  2. D

    Want to use VLOOKUP and IF for a code from another workbook

    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...
  3. J

    Change lookup of Match function

    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.
  4. T

    V-Lookup in a cell with more than one value present

    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...
  5. A

    Macro to Combine Data from Multiple Sheets

    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...
  6. S

    Vlookup

    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...
  7. N

    Trouble expanding cell range in a vLookup in a macro

    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 =...
  8. S

    VLOOKUP or Macro?

    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...
  9. U

    VBA: VLOOKUP If Certain Criteria Is Met

    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...
  10. WarrenCarr

    How to SUM IF marked cells

    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!
  11. M

    FILTER OR VLOOKUP !

    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...
  12. J

    Vlook-Up using a Macro

    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...
  13. B

    Reduce two formula commas into one

    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...
  14. M

    Looking for VBA code to split worksheets, break links, and save as a new workbook

    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...
  15. B

    lookup number and enter a word depending on row range number was found

    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...
  16. J

    Vlookuo

    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...
  17. J

    VBA Code to transfer from one file to another

    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".
  18. T

    Formula to show the earliest date from a range with criteria

    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...
  19. B

    VLOOKUP based on 2 headers of a single column (perhaps Index/Match is better)

    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...
  20. S

    Vlookup with two criteria

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top