-
=VLOOKUP($A2,'[Item Master - Supplier Data.xls]Valves'!$A$2:$I$200,2,FALSE) Hello I have my working sheet and another another file called 'Item Master - Supplier Data.xls' Supplier Data contains several sheets all in exactly the same format but with the data broken down into categories...
-
Sounds like your run of the mill VLOOKUP. However this has limitations (the lookup needs to be in asending or decending order). Otherwise you can use a nested INDEX MATCH formula. This has the advantage of not needing an ordered list but takes a bit of getting your head around to implement. Try googling...
-
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...