Status
Not open for further replies.
1 - 4 of 4 Posts

budward

· Registered
Joined
·
75 Posts
Discussion Starter · ·
I have this set of numbers that changes with each workout
5 2 4
9 6 3
1 0 7
I need to substitute each number using this key
0=5 5=0
1=9 6=4
2=8 7=3
3=7 8=2
4=6 9=1
I have included an example worksheet below
Thanks......Bud

Attachments

• 15 KB Views: 79

cwwozniak

· Super Moderator
Joined
·
75,202 Posts
The VLOOKUP function should work for you. Just create a table of two columns with before and after values and search for an exact match.

EDIT: This method creates a second table of the substituted numbers. It does not replace the original entries. After re-reading your post I am not sure if this is what you want to happen.

Attachments

• 16 KB Views: 88

budward

· Registered
Joined
·
75 Posts
Discussion Starter · ·
Thanks Chuck
It works the way I wanted.I did need the numbers in a seperate spot.

cwwozniak

· Super Moderator
Joined
·
75,202 Posts
You're welcome. Glad to help out. :up:

1 - 4 of 4 Posts
Status
Not open for further replies.