vllookup

  1. S

    Sorting with VLOOKUP

    I am working on a spreadsheet to track employee attendance. Cell A is the employee ID number, Cell B is the employee (=VLOOKUP(A573,$N$3:$P$131,2,FALSE), and Cell C is the position (=VLOOKUP(A671,$N$3:$P$131,3,FALSE). In cell E I have the date of the occurrence. When I attempt to sort by date...
  2. R

    Vlookup/Xlookup using a postal address

    i need to use Vlookup/Xlookup to pull data from one spreadsheet to another using the address to match address it is this format "7 example close, Example, BB4 9BB"
  3. L

    Vlookup hyperlink

    So I'm trying to use VLOOKUP in conjunction with a hyper link, I've tried this formula =HYPERLINK(VLOOKUP(name,table,column,0),name) but when I click it, it says "cannot open the specified file"
  4. S

    Vlookup Automation in VBA

    I'm urgently trying to automate a vlookup scenario. I have Dates in cloumns in short date format in Tab Subs Week and in Tab named Cinema-Data have Dates and 6 rows of Data in cross tab format. All I want to do is if Dates in Subsweek match Dates in Cinema-Data then I want to copy the...
  5. B

    vlookup index match difficulties

    So i am trying to create and evaluation sheet for my employees. The first screen shot is all the necessary data that i need to pull from. The second screen shot is where i want to put all my data to I can then use it for my evaluation sheet. I enter the employee name is the first column which...
  6. K

    Replacing Vlookup Formula witha more efficient substitute

    Good morning, We have a number of large spreadsheets which are full of vlookup formulas between multiple workbooks. I have started replacing them with Index Match and this has worked really well. We have a scenario where Index match doesn't seem to work, and i would like some advise on a more...
  7. J

    Vlookup and comments

    I have a large spreadsheet with data that I use the vlookup command with to copy information alternate worksheets. Many of the cells in the "data" worksheet have comments attached to them. When I use the vlookup command in other worksheets to retrieve data from cells of the data worksheet, the...
  8. I

    Vlookup - Final Occurence

    Hi I need a vlookup or something similar that I will return the final occurrence or match. The data I'm using has a lot of duplicates but i only need to return the last value. This is what I'm currently using if that helps. =IFERROR(VLOOKUP(B19,'Login - Logout'!$1:$1048576,6,),"-")
  9. T

    Not really sure what to use Vlookup, Index Match, Transpose ??????

    I've copied my spreadsheet with comments on both tabs, I wanted to upload the file but I don't see a link to upload the file. -- removed inline image --- -- removed inline image --- <tbody>...
  10. M

    VLOOKUP - One Criteria but having multiple table arrays

    Hi I am trying unsuccessfully to do a Vlookup based on one lookup_value but looking into multiple columns on different worksheets. The Lookup value is usually a text string concatenate several text and number cells together A1&B1&D1 125Apples55000 then find out if this string is present...

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