Hi there,
I would like request to solve my problem.
In A column : i have numbers 1,2,3
In B column : i have words "dog" "cat" "home"
*A and B means rules : 1=dog, 2=cat, 3=home
In C column i have many of : dog dog cat home dog cat home
I would like to replace words with numbers in column C based on rule described upper.
Is it possible?
(Similar make me vlookup - but its oposite, it replace number to word, but i need words in C column replaced to numbers)
Last edited by xbr088; 06-20-2013 at 09:23 AM.
You can not use a formula in a cell that you already have a value.. BUT you can hide column C and in Column D to use this formula...
=IFERROR(INDEX($A$1:$A$100,MATCH(C1,$B$1:$B$100,0)),"")
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Ok solved :-)
D1 start with : =VLOOKUP(C1;$A$1:$B$3;2;FALSE)
*BUT: A & B column HAVE TO BE REPLACED (A:"dog" "cat" "home" B:1,2,3)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks