-
Hey all - Geoff here - brand new to the forum and admittedly a novice-intermediate user of Excel (and its Mac cousin - Numbers). In my web search for the solution to my problem, I have already discovered the VLOOKUP and LOOKUP funtions and have it working. Cool stuff, but it does not quite do what I...
-
Hello, I have two spreadsheets that I'm looking to link together through a VLOOKUP or similar type function. The data I'm trying to reference is all laid out uniformly on the spreadsheet pages, although the pages have names that are not as simple as S1, S2, S3 - I am always going to be referencing...
-
In a table I created using transfer data from other programs, the vlookup function only retrieves some of the desired fields into the table from the selected array. Can anyone help? tks.....
-
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...