I am trying to get a formula that will display a number between 1 and 20,
depending on the contents of a cell. for example I have in "D1" the
following formula =if(d10=733,1,if(d10=738,2,if(d10=752,3........... .) etc
etc. It only goes up to 8 and I run into an error. How do I write my
formula in a cell on a "calculations" worksheet? Also, how can I put this in
a Macro, to copy and paste the data elsewhere on a seperate worksheet?

Any help would be really appreciated. I am stuck.

Create a table with the values in (for example) Sheet2 columns A & B
A B
733 1
738 2
752 3
etc

in D1 put:

=VLOOKUP(D10,Sheet2!$A$1:$B$20,2,0)

Not sure about your copy/paste requirement - what data?

"izzyt1972" wrote:

I am trying to get a formula that will display a number between 1 and 20,
depending on the contents of a cell. for example I have in "D1" the
following formula =if(d10=733,1,if(d10=738,2,if(d10=752,3........... .) etc
etc. It only goes up to 8 and I run into an error. How do I write my
formula in a cell on a "calculations" worksheet? Also, how can I put this in
a Macro, to copy and paste the data elsewhere on a seperate worksheet?

Any help would be really appreciated. I am stuck.

B C D E F G
H I J
| 01-Apr | 415426 | Thom | TOM4140 | G-THOF | 733 | 10:00 | 10:55 | 10:10 |

The above is a sample of the data in one of my rows . I need to run a
report based on date (B) or Catagory (D) or Reg (F) or a combination of the
3. This sheet has 1 month on a sheet. I have managed most other things, but
I am stuck on this.

Thanks. Iain

"Toppers" wrote:

Create a table with the values in (for example) Sheet2 columns A & B
A B
733 1
738 2
752 3
etc

in D1 put:

=VLOOKUP(D10,Sheet2!$A$1:$B$20,2,0)

Not sure about your copy/paste requirement - what data?

"izzyt1972" wrote:

I am trying to get a formula that will display a number between 1 and 20,
depending on the contents of a cell. for example I have in "D1" the
following formula =if(d10=733,1,if(d10=738,2,if(d10=752,3........... .) etc
etc. It only goes up to 8 and I run into an error. How do I write my
formula in a cell on a "calculations" worksheet? Also, how can I put this in
a Macro, to copy and paste the data elsewhere on a seperate worksheet?

Any help would be really appreciated. I am stuck.

A report of what?

Can you send sample spreadsheet plus clear explanation of what is required to:

toppers at REMOVETHISjohntopley.fsnet.co.uk

"izzyt1972" wrote:

B C D E F G
H I J
| 01-Apr | 415426 | Thom | TOM4140 | G-THOF | 733 | 10:00 | 10:55 | 10:10 |

The above is a sample of the data in one of my rows . I need to run a
report based on date (B) or Catagory (D) or Reg (F) or a combination of the
3. This sheet has 1 month on a sheet. I have managed most other things, but
I am stuck on this.

Thanks. Iain

"Toppers" wrote:

Create a table with the values in (for example) Sheet2 columns A & B
A B
733 1
738 2
752 3
etc

in D1 put:

=VLOOKUP(D10,Sheet2!$A$1:$B$20,2,0)

Not sure about your copy/paste requirement - what data?

"izzyt1972" wrote:

I am trying to get a formula that will display a number between 1 and 20,
depending on the contents of a cell. for example I have in "D1" the
following formula =if(d10=733,1,if(d10=738,2,if(d10=752,3........... .) etc
etc. It only goes up to 8 and I run into an error. How do I write my
formula in a cell on a "calculations" worksheet? Also, how can I put this in
a Macro, to copy and paste the data elsewhere on a seperate worksheet?

Any help would be really appreciated. I am stuck.