(Msg. 1) Posted: Fri Oct 17, 2008 8:11 am
Post subject: INDEX MATCH HELL ooops.. I mean HELP! Archived from groups: microsoft>public>excel (more info?)
I know (or at least I think I do) that I can do this with INDEX
MATCH. Here is what I want to do. I want to place this formula in
cell C4 of Sheet 1. What I want this formula to do is to match the
value of B2 of Sheet 1 with a list that is in Sheet 2 found in
C3:C24566. Once it matches these two values, i want it to return the
corresponding text in D2:D24566. I am pulling my hair out. Any
advice would be appreciated!!!
help with Index / match - I am using Excel 2003 and I'm trying to create a formula to look up a value in a Pivot table. The pivot table results would be: Date DB CVT ACD PKT 5/21 0.1 2.1 1.2 5/22 .01 1 5/23 1.1 ...
Visible row index after applying a filter in Excel - Does anyone know an excel function that will give the index of the visible row after filtering or sorting a table? Say, I have a table like this: type time place c 12:20 1 f 12:40 2 c 13:30 3 f 14:20 4 Table is....
Notation Bugs - Did anybody notice that Excel handles math notations (symbols) in an incorrect way? Try this: write -2 in cell A1. Write =1-A1^2 in a different cell. Write =-A1^2+1 in another cell. The two expressions are equivalent, shouldn't they? Well, the former..
How to create a single line separated by commas from a mat.. - Hello, I've the following problem. I've a table made of several columns. Each colum represents a characteristic regarding to a subject (e.g. Name, Surname, Home Street, etc...). In the rows I put the different people. I need to export these info to a....
Excel password Recovery - Hi All, i forgot my excel password, can any tell me how to recover the password there is any free tool is avail in web, Regards, Deen
You can post new topics in this forum You can reply to topics in this forum You can edit your posts in this forum You can delete your posts in this forum You can vote in polls in this forum
FAQ
Search
Profile
Private Messages
Log in
