Re: Lookup Function Error
tried that still returns the wrong text.
Re: Lookup Function Error
tried that still returns the wrong text.
Re: Lookup Function Error
hmm well ive tried vlookup also, and the probelem remains
hope you can help
thanks
Re: Lookup Function Error
sorry I accidently sent this through twice sorry for the inconvenience
Hi,
please see attached
look up formula is returning the wrong text from my look up table.
eg store name in column A, state in column B
cell A2 returing WA instead of SYD.
Formula that i am using is:
=LOOKUP(A1,lookup_table!$B$1:$B$38,lookup_table!$C$1:$C$38)
Many Thanks
Natalie
Re: Lookup Function Error Mismatching Data & N/a Error
thanks for your help but both seem to still give me the wrong data
Natalie
hi
my lookup isnt returning the correct data- already tried sorting it doesnt work im pretty sure ive put in the correct formula
pls see attached
Many Thanks for ur help
Natalieforum.ozgrid.com/index.php?attachment/21558/
Re: Changing Usb File Formats When Opening File From Usb
says erroe msg refers to location driveE:\\ that is unavailable
I think because the system at work runs on citrix and it is blocking out my usb???
Hi,
I have some excel files saved to my usb, but when I try to open them they open up in note pad and not excel?
Any ideas on how i can change this?
Many Thanks
Natalie
Re: Shortcut To Drag Down A Formula
Gee thanks a million Shg!
Hi
i have a formula that needs to be dragged down 65,000 rows in excel is there a quicker way of do it than with the mouse???
Many Thanks
Natalie
Re: Lookup Function Error
Wigi,
Thank you so much that was doing my head in....sorry for writing in the wrong forum----
That worked like a charm
cheers
Natalie
Hi,
Im trying to do a lookup but when I drag the formula down it returns the wrong values and also returns #N/A or #REF (which I think means it's refering to a wrong range and cant find the data???)
How can I do a look up function by dragging the formula down a long column of data eg. 65,000 rows in excel, that returns the correct text.
I have attached a simple example-pls see attached.
Your help is appreciated.
Thanks
Natalieforum.ozgrid.com/index.php?attachment/21465/
Re: Print Area In Spreadsheet
Its Ok Problem Solved Thanks Anyway....one Of My Colleagues Played Around With The Printing Settings And Fixed It - It Was Apparently Fixed To Letter Size Instead Of A4.
Cheers
Natalie
Hi All,
This may sound like a really dumb question but
I just need some assistance with File>Print Area
PROBLEM:
I have a speadsheet with data in it......every time I go to print preview it only shows the title and not the rest of the data.
I tried changing the print area as it seems to be set to only a few cells where the title is.
I also tried going to Tools>Options and changing something there but no hope.
Your assistance id Greatly Appreciated!
Natalie
Re: Plotting Currencies And Percentages
Quote from h1huse a seperate data series for percentages. Having millions of $ and % in one data series is something like adding apples and peanuts
How do i do seperate data series for the %'ages.... i tried doing it and it got rid of the other y axis and then distorted all other data series....
very unsure
thanks for your help h1h
Re: Plotting Currencies And Percentages
Sorry im not sure what you mean do you mean replace the axis scale with for eg 3;000;000 ?????
I thought that may be i needed to convert the percentage sections into decimal however i tried that and it did not work
any assistance will be greatly appreciated
cheers
natalie
hi please if can help me on this one:
I would like to plot a graph in excel that has 3 series, column d, e and f (s1, s2 and s3)
i have plotted these as shown in the attached however, where ever there is percentages it does not depict in the graph how do i do this???
help would be great thanks
Re: Adjust Margins Of A List
Sam,
Any ideas on this one......sorry I dont mean to be pushy (I guess we are all working on deadline here)
Your assistance is greatly appreciated!
Re: Adjust Margins Of A List
Quote from ReafidyIn page setup, select the Margins page.
Underneath the margins deselect center on page horizontally and vertically.H.T.H.
Sam
That worked fine but now I am having problems with the 2 margins parallel to eachother horizontially. Now every time i print the document, the gap between the page and the table is greater in width on the left side than on the right.
Re: Adjust Margins Of A List
Sam,
It was so simple as that! Thanks a million!!!!!!!