Question about Operating Systems

1 Answer

Vlookup Hi, Iam facing a problem in Vlookup function. In one sheet iam having invoice no:and Reciept details. In this sheet Same invoice no: is repeating for different reciept no: like Inv no Reciept no: 54 43 55 43 54 44 65 43 And in another sheet iam having invoice no: and I need reciept no: details for the Invoice no:. But If I run Vlook up it will pick only First reciept no: we will not get second reciept no: for ex: for Invoice no:54 we will get only Re.no:43 by running Vlookup. We will not get R.no:44. How to get both the R.no: against invoice no: Please help me.............

Posted by on

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Vice President:

    An expert whose answer got voted for 100 times.

  • Master
  • 981 Answers

You know, you really should have said it's an Excel problem, because it is; also your invoice and receipt numbers should probably be 10-12 digits long (yes, even if you do a mere 20 deals a year).

Add error checks and alerts to your spreadsheet, for starters; second, state the version etc. of the spreadsheet program you use, and how much memory is available on your system. VLookup often bombed or just gave the last result forever if it didn't have 130MB to play with. Other times it behaved if you ran certain initializations for it....

Posted on Mar 24, 2008

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Iam logged into face book but my language has changed from english to a foreign language


On the middle right top of your facebook page there is a small triangle please click on it and you will see menu then click on settings the fourth from down .click General on the right than you will see option language on the left .change it to English and enjoy. Regards

Sep 05, 2014 | Microsoft Windows 7 Professional Service...

1 Answer

How do you remove a watermark on Avid liquid 7.2 pro full version


Hi, Iam using avid liquid 7.2 and iam begner please tell me I would like to install one move in the corner of screeen this is water mark.

thanks

Mar 21, 2011 | Avid Liquid Pro 7 for PC

1 Answer

I have acer 730 emachine laptop and i want to know how i on its bluetooth .. iam using windows 7 in it


Look for either a keyboard combination or function switch but eitherway you will need to look through your documentation.

Aug 11, 2010 | Acer Operating Systems

1 Answer

My ds will not recognise the r4 card


iam having problem with 0xc000007b ,and iam using windows7 - it happend whan i used progdvb pro (loder crack) -shall i format? or

Aug 01, 2009 | Operating Systems

1 Answer

MY USB(2.0) PORT NOT WORKING


hi,
welcome to fixya.com,sir if u have already uninstalled and reinstalled the drivers and if u have already reinstalled the operating system and if it is still not working then simply replace the system motherboard.

Feb 14, 2009 | Microsoft Windows XP Professional With...

1 Answer

Teach c programming


a ghandu muje nahi ata

Sep 08, 2008 | Operating Systems

1 Answer

Virus


i think you are facing this problem due to the virus only ..
i think there is some virus in that yahoo messenger only ..
just install that copy & download the other copy of yahoo messenger and install it ..
if you persist the same problem then you system might have got attacked with the keylogger virus ...

so just install the updated antivirus & scan your whole system .....

if you have the antivirus installed already then just update the antivirus and then scan your system & clean the virus....


any doubts you can reply me
i am always here to assist you
thank you
bye .....
rate my solution

Jul 11, 2008 | Operating Systems

1 Answer

Startup problems


Hi,
this is telling you that a Scan/checkdisk program is running.
to get rid of this, run scandisk within windows, also go to Start/all programs/startup and remove from the startup if applicable.
to bypass on boot-up, simply press enter beefore the program Starts to run.

Mike @ compurepair.

Mar 08, 2008 | Operating Systems

1 Answer

Win98 and surfing problem


may be u r using dial up internet connection. g mail dosent load too fast like other emails . u can only view satandard htmla on dial up connections

Jan 22, 2008 | Microsoft Windows 98 for PC

Not finding what you are looking for?
Operating Systems Logo

Related Topics:

134 people viewed this question

Ask a Question

Usually answered in minutes!

Top Operating Systems Experts

Les Dickinson
Les Dickinson

Level 3 Expert

18304 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Prashant  Sharma
Prashant Sharma

Level 3 Expert

1127 Answers

Are you an Operating System Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...