Previous Topic Next Topic

Lookup or reference?

Closed
rebs - 8 Oct 2008 à 15:55
 Shandor - 9 Oct 2008 à 11:48
Hello,
I can't seem to figure out how to do the following
I need to enter a value four columns away from a name but want don't want to do it manually - in column b name is los angeles and i want for everytime "los angeles" appears, four columns away "98" shows up throughout my worksheet. can you help me write a macro for this?
rebs

2 responses

Réponse 1 / 2
Ivan-hoe Posts 433 Registration date Saturday 16 February 2008 Status Member Last seen 17 October 2008 110
9 Oct 2008 à 01:34
Hello rebs,
instead of a macro, you could write a formula in column F
=IF(B1="los angeles";98;"")
Ivan
rebs
9 Oct 2008 à 10:48
thanks, that much i can do. it's how to get "98" to fill in at b5, b33, b600, b750, b2000, etc. basically, every time "los angeles" is encountered in column b, i need "98" to fill in column g in the same row. i can't seem to get it to work.
rebs
Réponse 2 / 2
Shandor
9 Oct 2008 à 11:48
I think Ivanhoe was suggesting that you copy and paste that formula into ALL of the rows of the column that you want the 98 to appear.

if there are other numbers for other cities, you may want to look into the LOOKUP or MATCH functions

Similar discussions

How to invoke VLookUp function in Excel VBA.
Wingie -
TrowaD -

1 response
How to quote sources
Rubens94 -
dwebb -

3 responses
I canno get into my own google acct& gmail account
Christinetaniskishayinew -
CraigFDuran -

2 responses
Google Play sign in problem
abhi -
abhi -

2 responses
How do you setup Klipsch Cinema 600
Smokeyshowl -
HelpiOS -

1 response