-
Have a table of data and I need to interpolate a value. The row names are A,B,C,D and the column names have 0.5, 0.6, 0.7, 0.8 etc. If I want to look up in that table under row B for a column value 0.67, how would I accomplish that? Any ideas!?? Thanks!
-
Hello All, I am new to the forum and quite new to more complex functions in Excel. I have the following sheet: col1..col2 bmo..3 amd..1 dmq..2 smp..4 epm..1 I want to lookup the value "1" in col2 and return all the text strings in col1 that match. So in this instance I would have the result...
-
I'm hoping you can help me with a formula. I have a workbook that has 3 tabs. The first is the main log, the second I want to extract certain information on a line that's tied to 2 criteria (product name and tract number) and the third I want to have extract based on 3 criteria (product name...
-
Sorry to be coming in late, but I would have solved this just using qorksheet functions, namely VLOOKUP. Somewhere on the sheet create a table like this: A 110 - A B 120 - B C 130 - C D 140 - D Then in a cell adjacent to the cell you wish to replace, enter a vlookup formula along the lines of: =vlookup...
-
Felix I hope I have understood. (My testing had your Product ID (lookup value) in A1 and the Sampling Point Table in A4:C50 on the same sheet. (Just change these to suit)) I came up with this, which tests first if the Product ID exists at all using the AND function and ISERROR, if that returns TRUE I...
-
I have several spreadsheets which rollup to a higher level, summary sheet. Each sheet has a column of names and columns for each month with hours for each name for that month. I need these three spreadsheets to rollup the hours for each person to the summary level spreadsheet. I currently use VLOOKUP...
-
You simply need to use a VLOOKUP against the data in the original list (remember names may not be unique so you may need to join a few fields together to be more certain). If your names are in A1:A9000 on Sheet1 and your 2000 new customers on sheet2 in the same book, A1:A2000 then in B1 on the first...
-
I have 2 worksheets. WkSht1 has 1 column A Client name Bob Tom WKSHT 2 has two columns Col. B has multiple client IDs per Client in Col. A A B CLIENT CLIENT ID Bob B123 B456 B789 Tom T321 T654 T987 There are variable numbers of IDs per Client I need a lookup to match on the client from WKSHT1 and retrieve...
-
Sherrie Ann VLOOKUP will go from top to bottom and then when it finds a match it will take the value from x number of columns to the right. (Signified by the offset attribute). Therefore if you are sure that the match you want to find is the first from the top, that is the value that is returned. VLOOKUP...
-
I have a spreadsheet of addresses that was scanned using OCR. The scanner did an acceptable job of text recognition, however due to additional Title's (i.e. MD, PhD, RN, etc) the columns in excel became wildly unmanageable. I need to extract Telephone, Fax and E-mail from a long list of contacts...