I have a excel file with the following:

field1

100

101

100

102

103

100

101

103

In two fields I have the following

100 | cat

101 | dog

102 | hat

103 | duck

So in field1 how do I set it so if field1 = 100 then change that to cat

If 101 then change it to dog?

Do anyone know what kind of forumula i should use?

## 7 Replies

Lookup function is what you're after.

https:/

you are right the lookup function is what i'm after. I still cannot firgure it out. can you guide me on how to look on one.?

can you give me an example. attached is an example of excel.

how do i get the field to come out the tag?

Put this in Cell A2.

=VLOOKUP(100,E2:F6,2,TRUE)

Then change the 100, for each number you want to look up.

Rather than the 100, put a reference to the cell. Put the VLOOKUP function above into cell to the left and put dollar signs on $E$2:$E$6. From there, fill down and copy/paste values to put the words in place.you are right the lookup function is what i'm after. I still cannot firgure it out. can you guide me on how to look on one.?

can you give me an example. attached is an example of excel.

how do i get the field to come out the tag?

Put this in Cell A2.

=VLOOKUP(100,E2:F6,2,TRUE)

Then change the 100, for each number you want to look up.

Please note that I did not look at your spreadsheet while providing this tip!

Rather than the 100, put a reference to the cell. Put the VLOOKUP function above into cell to the left and put dollar signs on $E$2:$E$6. From there, fill down and copy/paste values to put the words in place.you are right the lookup function is what i'm after. I still cannot firgure it out. can you guide me on how to look on one.?

can you give me an example. attached is an example of excel.

how do i get the field to come out the tag?

Put this in Cell A2.

=VLOOKUP(100,E2:F6,2,TRUE)

Then change the 100, for each number you want to look up.

Please note that I did not look at your spreadsheet while providing this tip!

He said he wanted it to replace the value in A2, but if I read that wrong, then what you suggest is better.