vlookup

Working out which cell Vlookup refers to

Hi, say if I see this Vlookup formula in my Excel spreadsheet: =VLOOKUP(G37,'tb 2008'!$H$142:$M$247,6,FALSE) Then is there an efficient way to find out which cell it is referencing? I don't want to manually perform the Vlookup in my head to find out which cell it found that fits the parameters. ...

Making a list through vlookup in Microsoft Excel?

I have a table in excel with three columns: name, organization, contract expiring (YES/NO). I have 20 other sheets, one for each organization. On each sheet, I want the names of the people whose contracts are expiring from that company. I can do a vlookup for the first one listed, but I need the full list for each organization. Any sugg...

Postgresql vlookup

Let's say I have a table "uservalue" with the following columns: integer user_id integer group_id integer value I can get the maximum value for each group easily: select max(value) from uservalue group by group_id; What I would like is for it to return the user_id in each group that had the highest value. The max function in matla...

External references not working

I am having problems with external references not working when the source is closed. I am using a vlookup to pull data from the source file, and when the source is open the references work. I have tried including the location along with the file name in the formula but it still is not working. Please help :) ...

Referencing variable workbooks in Excel using VBA

Hello, I have a scenario where a user creates a workbook, then this workbook (let's call it A) is assigned a variable. Later on down the line, the user creates a second workbook (let's call it B), which is assigned another variable. The names of these workbooks are not fixed, thus they are always variables. Now I want to do a VLOOKUP...

VLookup in Datagridviews (VB.NET)

Hi, I have 2 datagridviews (say, DGV-A and DGV-B) having just one column each. I want to find whether the item in DGV-A also exists in DGV-B. Basically, I am looking for a VLookup function available in MS-Excel. This can be done trivially, bus iterating over the values in DGV-A and for each iteration of DGV-A, iterate over DGV-B and se...

Vlookup, Google Docs., Filter & Sum

I have a row with a cost, item type and a "tags" columns. I want to be able to find the total cost of all rows containing a certain "tag". I tried using VLOOKUP but I keep on getting a $0.00 return. Example Row Setup: PART NUMBER - COST - TAGS - MANU ID - WEIGHT 0001025-SVR - 25.99 - JP, CABLES, PVC - 17.4 0A06422-SVR - 14.2...

Find value within a range in lookup table

I have the simplest problem to implement, but so far I have not been able to get my head around a solution in Python. I have built a table that looks similar to this one: 501 - ASIA 1262 - EUROPE 3389 - LATAM 5409 - US I will test a certain value to see if it falls within these ranges, 389 -> ASIA, 1300 -> LATAM, 5400 -> US. A value ...

Question regarding optimal excel function implementation

Hi everyone, I have a question about Excel! I hope that isn't too unconventional for this site... So I have an Excel table with several thousand rows. It is kind of setup like a db in that the first three of my four columns have numerical values identifying the sequence or order that the content or fourth row contains. I am running int...

VLOOKUP no longer works in Office 2007 - Excel

Not sure how a feature that worked fine in previous versions no longer works but I figure there must be a new way to do it that I am unaware of. I have a simple VLOOKUP. I have a column (Book#1-ColA) of values (suburbs of Australia) In an other book (Book#2), I have two columns, (Suburbs (ColA) & Postcodes (ColB)) In Book#1-ColB i pl...

VLOOKUP according to LOCATION but not the absolute name....EXCEL VBA help please!

Hello, i put the name of the files i want to perform in some cells and wrote a maco for excel to call up the file according to the location. (lets say I write 1.xls in cells Cells(2, "B")) e.g. A = Cells(1, "B") B = Cells(2, "B") C = Cells(3, "B") Workbooks.Open Filename:=A Windows(A).Activate Now, i want to do VLOOKUP by lookin...

Use cell value in vlookup formula

=vlookup(c2,code1,2,false) I am using the vlookup code but I would like to use the cell value in 'c2' rather than c2 itself. The value within this cell will change, at the moment it is 'aj2'. Is there an easy way of doing this? Hi Thanks, that doesn't seem to work for what I want. I suppose it might be easier if I explain what I want ...

EXCEL VLOOKUP FUNCTION | When switching to another doc, Function Argument window disappears?

Hello! I have problem with Excel 2007 when using VLOOKUP function. After switching to another document for referencing value in "Table_array" field, window dissapears. Google finds some results about the problem, but nothing helpful. Following things have already been considered: - Security problems (Trusted center is OK, settings too...

Using vlookup in Excel to match a Surname and First name and output unique ref number?

I have a spreadsheet which has 3 columns Col A is a unique reference number Col B is the surname Col C is the firstname In another worksheet I want to be able to type in a surname in cell A2, a firstname in cell A3 and have cell A1 automatically populated with the unique reference number. Is this possible in Excel and if so could you ...