Multiple If Statements

[SpyderPB6]

Not sure if this would be a macro or not...

I would like to implement multiple if statements. For example:

If Cell A1 = "this" then B1 = "that"

or

If Cell A1 = "this1" then B1 = "that1"

or

If Cell A1 = "this2" then B1 = "that2"

or

If FALSE then B1 = ""



I have about 80 statements I would like to work into a macro, but just need guidance on the basic structure of the macro.

Thanks so much for any input.

[g8r777]

Without fully understanding what you are tyring to accomplish I would think at first glance that a macro solution using "Select Case" would be cleaner.

Example:

Please Login or Register  to view this content.

Hope this gets you started in the right direction.

[djapigo]

Why not just use a VLOOKUP?

[SpyderPB6]

@ djapigo

I am not familiar with that. Could you elaborate?



@ g8r777

Your code works very well here. I've modified it to show you where I am working.

The goal from here is to extend this all the way down. It creates a value from the data in cell H2 and I need to go down the entire column.

Please Login or Register  to view this content.

Thanks for both replies.

Have a great day,
Mike.

[djapigo]

Mike,

VLOOKUPs do not need macros... it's a simple formula with little setup (table range)... you should look up the VLOOKUP formula...

Here's an example... vlookup sample.xls

This will be much easier to monitor and change. Then again, I'm not sure what you are trying to do.

Let me know if you still have any questions.

Thanks,
Dennis

[martindwilson]

wont a formula suffice?
=IF(A1="this","that",IF(A1="this1","that1",IF(A1="this2","that2","")))

[djapigo]

Martin,

80 nested ifs might be too much

[martindwilson]

missed the 80 bit! but a vlookup or index/match would be pretty straight forward

[g8r777]

I agree that a VLOOKUP will probably work in this case and be easier than coding.

I originally thought he was going for something that would have another embedded case.

Something like

Please Login or Register  to view this content.

In this case I didn't think VLOOKUP would have worked as well. I also thought he had more code to run depending on the various cases.

[Pete_UK]

Depending on what "this" and "that" actually are, it might be possible to calculate them (if they are numbers).

Pete

[SpyderPB6]

@Dennis

That worked very well. I never knew such a formula even existed. I just applied it to over 4000 rows, with a range of about 85 categories. You have saved me much time, definitely easier to work with than a macro.



@ Everyone Else,

Thanks for your input as well. That macro works very well, but no doubt this VLOOKUP is much easier.

This and That were 80 or so different product categories. No numbers here.

Basically it was if it is this product type, assign it that product category.



Thanks again everyone!

Have a great day,

MIke.