Thread
:
Using VLookup and typing in values to be "looked up"
View Single Post
#
3
Anne Troy
Posts: n/a
Perhaps you need to clear the formatting of C2. Edit--Clear--All.
Otherwise, perhaps C2 is seen as text and not as a number. See Data isn't
recognized...
http://www.officearticles.com/excel/...soft_excel.htm
*******************
~Anne Troy
www.OfficeArticles.com
www.MyExpertsOnline.com
"Graeme LN" <Graeme
wrote in message
...
I am trying to select a value from a worksheet corresponding to the value
I
am typing in on another worksheet. Eg I type in a product number and it
selects the description for that product from another worksheet. I use
=VLOOKUP(C2,$A$2:$B$10249,2,FALSE)
where C2 in wksheet 1 = the value in column A in the range A2:B10249 in
wksheet2 and the product description is in column 2 of that range.
When I type in the value at C2, it returns #N/A. When I copy and paste the
value from column A in A2:B10249 it returns the correct description in
column
2. The cell formatting seems to be correct.
Reply With Quote