We want to make a vlookup on 2 columns ex;if a :b match with other woorksheet
the contents of c:d shall be updated from second c:d
explanation
a: john b:Doe c;(address) d:(city) the c d shall get filled from other

I need to compare two different spreadsheets. One spreadsheet has ticket
numbers and amounts. The other spreadsheet has ticket number, amount, name,
and product name. I need to be able to compare ticket number and amount on
both spreadsheet. If they match, the name needs to be ...

How can I do that?
Thanks

I can't figure out the way I should create this conditional formatting. It's
probably very simple though.
If a cell, let's say J5, is empty for three days, then the background of
cell A5 turns red.

Let me start off by saying that I have been using Excel for several years,
but self taught. I have come across a new challenge that I just can't figure
out. I am attempting to create a formula that will automatically change the
color of a specific cell if another specific cell ...

I am trying to do a simple IF function but don't know how to indicate if a
cell is empty or blank then I want a certain text value returned.
What I am trying is:
=IF('Sheet 1'!A15=IS NULL,"NO","YES")

I have a workbook on the server, that links to multiple files from
different users.
I used Paste Link to acheive this. Because the number of rows can
increase, I selected the columns in use, and paste linked those.

Use the example below, "," is the delimiter between cells.
item1, content1, code1, 111
item2, content2, code2, 23
item3, content3, code3, 11

Is it possible to have a cell background color change when a particular
condition is met?
In this case, specifically a DATE.
When an item is entered in a row, one of the entries is the current date.

I have several workbooks with date-formatted cells that work properly.   I
just created a new one, however, that will not display properly.  I have
tried several "date" settings and also the "custom, d-mmm-yy" setting, yet
information placed in the cells come up as a date in "Jan ...

I have a need to select and store unique cell contents in a large number of
rows.  I guess I would like a formula that looks something like
=unique(a2:a22,","," ") where the information I would to test is in cells a2
through a22, seperate the contents of the unique cell contents, ...

Version - Microsoft office 2003 - Just a regular spreadsheet with data.  I
have clicked into one of the cells & im trying to add a pivot table however
when I go to select it it is greyed out as in not an option to select?

A long time ago I had some code to add a drop down menu to Excel. Can some
kind soul please direct me to a location where I can recapture that
code.\Thanks

Here is what I want to do:
If a cell (formatted as number) is between 0 and 10 multiply it by this.  If
it's between 10 and 20 multiply it by that.  How do you write that?
thx

I have a set of about 50 source files, each with 5 named ranges (one
name range on each of 5 tabs).  I am trying to create a macro to copy
the named ranges for each of the source files to the corresponding tab
of a destination file so that the destination file contains a column