Good afternoon from 12 degrees C wetherby UK :-)
I have two columns. One column has text values the second numeric. All i want to do is get excel to return values if they match a specific text field. For example if a column says "ask" (Text Data) i want to return its associated numeric value in column B.
Here is the formula Ive been using:
=LOOKUP("ask",A1:B28)
Here is an illustration of the actual problem:
http://i216.photobucket.com/albums/c...psfc79fbcc.jpg
But i just cant get me head around why it does not return the correct value.
Any help much appreciated, I feel ground down by what i thought would be straight forward :-(
Grazie tanto,
David
Bookmarks