#vlookup

Hi, I'd love to receive some feedback about have the right formula for this problem, I'm getting crazy so bad because I understand what I need but regardless I can't find the right formula. I explain what I am looking for: I have this first table, Column where the RATE is have to show the price...

Hi, I receive shifts from one source in a table and I have the availability of staff in another source in a table. I would like to return the name of the staff that is available in the column 'Name' in the Shifts Received table. I have tried using INDEX and MATCH but I'm struggling as I need...

Sub fetch_data() Dim arr() Dim arr3() Dim arrp() Dim arr1() Dim filteredArray() Dim totalRange Dim i, j Dim Str Dim endRange As Range Dim wb As Workbook Application.ScreenUpdating = False Application.Calculation = xlCalculationManual Application.EnableEvents = False Path = ActiveWorkbook.Path...

I hope someone here with better Excel skills than me can help. I maintain an Excel file which is used by Power BI to provide weekly status of a Fantasy Football (Soccer) league operating at my place of work. There is one tab in the Excel that has 4 columns, the first is the game week number...

Is there any possible way is there to lookup values on the left. To fetch the values from the left of the reference column.

I need to create a VBA VlookUp that will go through Col A to H in a Sheet2 tab(the table_array), match it with column V(look_up value) in Sheet 1 and put the matching results(which is the column index and its in column 7) in cell AD. I was able to test this for a very small range of values...

Hi All, I have a series of columns for orders on my spreadsheet. The furthest left column contains item numbers, the second column contains the quantities ordered whilst the final column contains the item names. I'm trying to find a way whereby any items that are ordered multiple times have...

Hi, I have two lists of Accounts that I need to consolidate. These lists come from two different sources and in a lot of cases the individual names are slightly different. Ie One list has 'AC Nielsen', the other one has 'Nielsen Media'. The best tool I have found so far is a partial Vlookup...

Hi, I have some formula's that I am trying to replace using Power Query.... not sure what the best way to explain this is but I will explain the scenario in excel first. I need to look at column 1 and return the value specified in the lookup table, but if the number doesn't exist in column 1...

hi, I need some help with a vlookup, any help would be greatly appreciated! I need to look at column 1 and return the value specified in the lookup table, but if the number doesn't exist in column 1 lookup table, i want to lookup column 2 and return the value based on the lookup table. Any...

Here is the table to help you understand the problem. <tbody> r1 8B GA ID IL IN IW JT QG ABU-KOE 14 AEG-KNO 7 AMQ-BXB 1 AMQ-CGK 14 35 14 7 Routes Competitor ABU-KOE IW AMQ-CGK GA, ID, JT, QG </tbody> What...

Hi all I have a spreadsheet that requires a reference number (SDAC REF) to be input which then triggers the VLOOKUP for the SDAC Name & STW Catchment. This all works fine until a reference number with (????E1??) is input, this then changes the cell to Scientific and the VLOOKUP does not work...

Wow trying to put a title to this was hard. So here is the issue and I have been racking my brain to figure it out and I am at a loss. I have a productivity report and I need to look up how many contacts the rep did from the previous day on a different tab. This Report is continually added to so...

Hi all, The titles says it all. I would like to get a sum value via lookup based on if the text thread matches my search criteria. Below is an example of what I would like to do! <tbody> <tbody> Placement Name </tbody> <tbody> Spend </tbody> <tbody>...

Hi guys, I'm a noob in this area but I'm trying to make my daily job easier... To do so, I created an excel order page with some VLOOKUP and data validation dependent dropdown lists. I have a mess with internal codes and linking between codes so the purpose of this tool is to always return the...

https://app.box.com/s/wrtv64g0fx4o0gexeott0ba12j1ykd0g https://drive.google.com/open?id=0B1GJKIl2o1WZam5HZ25oRGo5TTA Cell F38 should show .3798 in stead of 5 Cell F39 should show .4899 in stead of .8880 Cell F40 should show .5769 in stead of 1.3130 Can anyone explain

https://drive.google.com/open?id=0B1GJKIl2o1WZb0RJODV0ak9QQnc Password: cfc47& Cell F38 should show .3798 in stead of 5 Cell F39 should show .4899 in stead of .8880 Cell F40 should show .5769 in stead of 1.3130 Can anyone explain

Hi, I wonder if anybody could help with this one: You have a table with invoice numbers and amounts by vendor. The job is to add a "User" column into this table using vlookup and/or other excel functions showing User1/User2/User3 linked to each vendor name, when you have a reference table on a...

I have two worksheets. Both worksheets have a column with the the same reference numbers. Those reference number will then be used as point of reference to pick up values in the same row as the reference number from one worksheet to another. Is there a way to do this using a macro? Please help...

Hi, I have a Vlookup problem. =IF(ISBLANK($B14)=TRUE,"-",VLOOKUP(B14,'[Tarif pièces détachées-Spare parts price list 2015-V2.xlsx]Tarif 2015 '!$A$1:$B$65536,2,FALSE)) my formula is working and returning a value and in 95% of the times it is correct. It has specific problem when looking...