Question about Microsoft Excel for PC

1 Answer

Lookup function Can it be the value of lookup_vector in Lookup function is a clip art or jpeg image?

Posted by on

  • sonal borase Oct 13, 2008

    plz tel me abt look up fun

×

1 Answer

  • Level 1:

    An expert who has achieved level 1.

  • Contributor
  • 1 Answer

I have one date sheet old one another new with some modifications how to share the data from old sheet to new sheet pls tel me with formula and example

Posted on Nov 07, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

3 Answers

What is vlook up & what is hlook up?


The VLOOKUP and HLOOKUP functions contain an argument called range_lookup that allows you to find an exact match to your lookup value without sorting the lookup table

I have posted below link to know more .Please have a look..

http://www.howtodothings.com/computers-internet/how-to-use-the-vlookup-and-hlookup-functions-in-microsoft-excel
http://support.microsoft.com/kb/181213

http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx

http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel

Please rate & vote if you like soution..

Thanks
Sandeep

Mar 14, 2011 | Microsoft Excel for PC

1 Answer

I built a spreadsheet that uses a lot of DSUM equations to analyze a database of transaction information. I'm noticing that it is taking a very long time for the spreadsheet to calculate, even after...


The DSUM function is very useful, but it does use a lot of processing. Every DSUM function does a scan of every row of your table. There are a few ways you can reduce computing time.
First (and the most obvious) is to reduce the number of DSUM functions or reduce the size of your table. I presume you have already tried this.
Secondly consider using Pivot Tables to do the task, or to reduce the size of your table. There is a Pivot Table wizard under the Data menu. It's a fairly user friendly feature of Excel, so I suggest you try it out on your table. Pivot tables will be many times faster than DSUM functions because they only scan the table once. There are some tutorials available on the internet.
Third, if your DSUM functions are only summing one value in the table, then it would be much quicker if you can sort the table on the lookup value (or criteria). Then use LOOKUP, VLOOKUP or MATCH functions to find the value you're looking for. On a sorted table, these functions are many times faster that DSUM functions.
I hope this helps a little. It's hard to diagnose without seeing the spreadsheet and knowing the details of the problem you are trying to solve.

Oct 23, 2009 | Microsoft Office Excel 2003 for PC

1 Answer

Need an excel formula.


The crude solution is:
=IF(Sheet3!I2="WA",IF(Sheet3!H2="Vancouver","X",IF(Sheet3!H2="Camas","X",IF(Sheet3!H2="Ridgefield","X",IF(Sheet3!H2="Washougal","X",IF(Sheet3!H2="Stevenson","X",IF(Sheet3!H2="Hockinson","X","?City?")))))),"?State?")

Where ?City? appears when the city referenced in H2 is not part of the lookup
and ?State? appears when something other than WA appears in I2.

But there is probably a better way to do this using an array of valid values like the one below:

AL NY TX WA Birmingham Albany Abilene Camas Huntsville Buffalo Galvaston Hockinson Russell New York Houston Ridgefield Stevenson Vancouver Washougal

In the scenario you could stuff the array in another worksheet and use the HLookup function to find the "Sheet3!I2" value in the first row of this array to determine which column to look in, then VLookup "Sheet3!H2" in the column of that array to see if the city referenced exists. Of course this is a much more complex formula, but it would be easily extendible without changing the formula every time.

For mor info, see "Lookup and Reference Functions" in the Excel Help.

Jun 11, 2009 | Microsoft Excel for PC

1 Answer

Regarding the value to be know


Yes, you would do a LOOKUP do display the row number.

LOOKUP(H53,A1:G1000,0)

Feb 18, 2009 | Microsoft Business & Productivity Software

1 Answer

What is vlookup & hlookup?


1024x768 Normal 0 false false false /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} These are Excel functions for Lookup tables. The purpose of Lookup tables is to bring a value to the table, find the closest (or exact) match, and then return another value.

An example is the federal income tax table. On your tax return you get your gross income and number of dependents, go to the Lookup table, and find your taxable income.

The V in VLOOKUP means that the table is vertical; HLOOKUP has a horizontal orientation.

If you use the Insert Function button in Excel and paste either function, the dialog box will explain each required field separately with examples.

Dec 02, 2008 | Microsoft Excel for PC

1 Answer

I WANT TO KNOW ABOUT HLOOKUP IN MS EXCEL.


HLOOKUP is an excel function to lookup the horizontal row value you specify.

Nov 13, 2008 | Business & Productivity Software

1 Answer

HLOOKUP IN MS EXCEL


lookup value = value searched

table array = database

topmost row of lookup array must contain the data IDs and all IDs must be sorted in ascending order.

row index number = row number containing data to be shown; first row = 1

hlookup(x,tablearray,y) will look for x on the first row of the lookup table and return the value in the cell on the yth row

if formula cannot file exact x, it will look for the value closest to. but not greater than x

Nov 13, 2008 | Business & Productivity Software

1 Answer

How do I say look at cell on left rather than the cell number


vlookup can only locate values within the lookup range and to the right of the lookup column. to address your concern, i'd advise you to create a dummy column within the lookup range (and hide it) and link it to the lookup column. this way, we won't need a (-) column index number.

Oct 31, 2008 | Microsoft Excel for PC

1 Answer

Formulae problem


The problem doesn't say this explicitly, but it looks like you're using Excel. This answer depends on that assumption being correct.

Are you saying that some of your inputs are blank? And LOOKUP fails to map them to 0? Or are you saying that some of your values come back from LOOKUP as blanks? (They shouldn't; lookup should return either a value from the lookup table or an error.) Or is it the case that some input values get mapped to blank by your LOOKUP function?

Assuming that you're getting blanks back from LOOKUP where you wanted zeros -- for whatever reason -- here is something you can try.

It looks like the value you're looking up is in cell A3. Let's say your formula (the result of the LOOKUP) is in B3. In C3, you can put the formula =IF(ISBLANK(A3), 0, A3). This function tests if A3 is blank. If it is, it returns a 0. If it's not, you get A3 again. (But A3 has to really be blank -- spaces will count as non-blank.)

Then, you can copy data out of column C instead of column B, and it should have zeros in place of blanks.

Jan 05, 2008 | Business & Productivity Software

3 Answers

About function


I love vlookup! Suppose you have 1 worksheet with song numbers and titles in Row 1, Cols A:B: Song# Title 123 Love Me Tender 234 Blue Suede Shoes 345 Dixie Another worksheet has song number and performer in Row 1, Cols A:B Song# Performer 123 Elvis Presley 234 Carl Perkins 456 Cher Notice there is NO performer for song number 345 in the 2nd worksheet. Now in the 1st work sheet, cell C2 insert this LOOKUP function: =LOOKUP(A2,Sheet2!A:B) Copy that cell to row 3 and row 4 in Col C. You should get a Performer for all songs even though there is not a song number 345 in the performer worksheet. Help me out Mr. VLOOKUP. Insert this VLOOKUP function in cell C2 of the first worksheet: =VLOOKUP(A2,Sheet2!A:B,2,0) Copy that cell to row 3 and row 4 Col C. You should get the performer names for the 1st 2 songs, but not for 345 Dixie. The result should be #N/A. That means VLOOKUP could not find a DIRECT match for song 345 in the second worksheet. That is why I prefer VLOOKUP over LOOKUP. I have found this explaination of the VLOOKUP parameters helpful: 1. Needle (A2) 2. Haystack (Sheet2!A:B) 3. RELATIVE Col containing result (2) 4. Need DIRECT MATCH ONLY (0) Hope this helps. Let me know if you have any questions.

Aug 27, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

61 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18299 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...