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. ...
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...
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...
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 :) ...
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...
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...
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...
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 ...
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...
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...
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...
=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 ...
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...
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 ...