Question Locked
What formula in excel do i need?
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Hello
I am stuck!
When i type something in a cell eg. 1c, i need it to look at a block of cells, find the 1c in that block and then return the corrisponding number. so if i type 1c it will change to the number, say 3, that corrisponds in the legend.
I prob haven't explained it very well
Shazz