This formula below works as shown
=IF(D10=0.5,(VLOOKUP(I10,Table_A,2,0))). the result is shown in 'J10'
But 'D10' has 9 possibilities and 'I10' has to look up 9 tables; Table_A
through Table_I which are in sheet three. for each possibility there is a

in the screenshot below, i want to merge the cells at the bottom
(-idaman tegas-) so that it looks like the one at the top, -maxisegar-
(all data in one cell rather than spread over several cells). the
person who did the spreadsheet wasn't consistent and now i'm stuck with

Folks,
I've spent a fair bit of time perusing this and other groups.  Two
things were very apparent to me.  First, I don't know much!  Second,
I'm so far out I don't even know what to ask.  The questions that

I am trying to create a spreadsheet for doing bids at my job.  On one
worksheet I view things like quantity, description, and product cost as
well as the sale price, etc.  On another worksheet I have created an
invoice for the customer.  What I want is for the data on the first

Hello, I'm looking for a way to quickly find what numbers are missing in
column B. I can sort them ascending, but how do I find if there are missing
numbers?
1

I want to highlight every row that has a certain word in one column and a
different word in another column of the same row.  How do I do this?
SteveK

I'm switching computers.  Where do I put my old XLB file?
Ed

I am trying to protect my excel spread sheet doc, where it will require to
enter a password prior to opening the document, each time someone wants to
view it.
Thanks,

I am a new Excel user and I am having some trouble. I split a column of data
seperated by semicolons into several columns. Now I have a bunch of cells
with a leading space and it is screwing things up when i try to sort
alphabetically. How can i create a macro do delete the ...

Hi guys, I hope you can help me with this one.
In a cell I may have a value like 0.05 or 0.16 or 1.16 (these are dollar
amounts)
I will like to format these numbers following this criterion:

Problem:
When I enter the following equation into a cell with a blank in cell
CH12 or CH13 I get the correct answer (the sum of the cells with
numbers in them) but when there is a blank in cell CH14 I get an

I have just added the Report Add-in for Excel2000 (I know, I'm a dinosaur;
but it works for me). I'm guessing the same problem applies in Excel2003.
When I click on 'VBAProjects(report.xla)', it asks for a password.
Nothing in my Excel system is password protected. Of course, I ...

I used to have windows 95, my new m/c has windows xp. It seems to be set up
in a certain "mode". I'm unable to delete headers and or footers in excel . I
do not wish either
George

I have this formula in use and it works perfectly.  I now need to change the
sum area from H4:h484 to H4:J484 and now it only give me 0.  How do I get it
to sum the larger area??
=IF($B3<=0,"",SUMPRODUCT((SVEexp!$B$4:$B$484=Summary!$B3)*(SVEexp!$C$4:$C$48

I have a cell/column with 9-digit social security numbers, no spaces, no
dashes.  I need the last 4 numbers of each cell copied into a seperate
cell/column.  I can't find anything about copying partial cell value.  Can
anyone please help?  Thank you,