Hi all !!
Say I have a column of 1's and 2's
and I want to replace all the 1's for 'cat', and all the 2's for 'dog'.
On the second sheet I have a reference table:
1 cat
2 dog
Which formula should I use and how?
I've tried vlookup, but that doesn't seem to work because of circular error since I want the value returned to replace the reference..
Hi
to change the value of a cell that way you'll need VBA
Or use 'Find and Replace' (Ctrl-H)
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Appreciate your suggestion.
But I can't use the find and replace, the spreadsheet is huge, and growing with way too many variables.
I need a formula.
Hi,
Not sure I understand. Can you explain a bit more why you can't use Find and Replace?
Regards
Sorry maybe the example I gave was too simplifying.
The spreadsheet is a data survey with more than 50 questions.
The way the survey was designed was to return a different number for every answer (label) . What I am trying to do is replace all the numbers for their labels. So there's more than one column, and for every column the numbers correspond to a different label. The spreadsheet is also growing continuously, so find and replace would be very time consuming..
Last edited by paul_drive; 11-22-2013 at 01:41 PM.
Maybe this will work for you
In B1
=IF(A1=1,"Cat","Dog")
Cat Cat Dog Cat Dog Dog
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks