I need a formula that will do this for me: Look for a specific number in column B of another specified sheet, then take the entire row of the number/s found and copy them to the location where I w...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_101...
Zones:
MS OfficeDate Answered: 06/11/1999 Rating: 7.6 Views: 0
When I use a VLOOKUP formula such as this:
=VLOOKUP(E9,A38:B42,2)
I'm having it look at cell E9 for the
value to reference... but...
What if there's nothing in cell E9 ?
(I like to fill...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_203...
Zones:
MS OfficeDate Answered: 10/29/2002 Rating: 7.6 Views: 0
I have written a rather clumsy multi cell formula for searching a 2-d table and interpolating between both the x and y axes. I'd like something more compact, if possible, or a short visual basic m...
http://www.experts-exchange.com/Software/Misc/Q_20456986.html
Zones:
Misc SoftwareDate Answered: 01/29/2003 Rating: 5.2 Views: 0
I am trying to complete this homework assignment and am coming up baffled. here is a link to the assignment:
http://www.cob.niu.edu/faculty/m10rle1/omis351/Page.htm
I have been trying for a f...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_204...
Zones:
MS OfficeDate Answered: 04/21/2003 Rating: 6.8 Views: 0
I have a timesheet-style worksheet with the following structure:
"John Doe / 6-1572 || 36" in Cells A1:A2 Merged, "Time IN" value in cell B1, "Time OUT" value in cell B2. And so on for 30 peo...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_205...
Zones:
MS OfficeDate Answered: 04/15/2003 Rating: 9.0 Views: 0
This is the lookup table for API and Temperature. Sample
A B C D E F G H I J
1 10.0 10.5 11.0 11.5 12....
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_206...
Zones:
MS OfficeDate Answered: 02/13/2004 Rating: 8.0 Views: 0
I have a model that calculates a final % by multiplying base data by a series of events in the order of the events date rank. The calc works fine but I've added some functionality that updates the ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 09/03/2003 Rating: 8.6 Views: 0
I have a spreadsheet using Vlookup to get description, primary mfr pn, mfr pn alt1, mfr pn alt2 etc...
What I would like to do is be able to pull a photo of the part as well as the data, is this p...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 09/08/2003 Rating: 7.4 Views: 0
hi i have created a spreadsheet, and within a wookbook a am using the 'vlookup' formula to help extract certiain information according to the 'look up value'. if i enter a lookup value, and there a...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_207...
Zones:
MS OfficeDate Answered: 11/01/2003 Rating: 9.2 Views: 0
Hello:
Nothing seems to be working for me tonight...
I have a workbook with worksheet named InvRegister:
Cell A(Inv #) Cell B(date) Cell C(Name) Cell D(Premium)
221...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 12/22/2003 Rating: 7.0 Views: 0
