Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using VLookup and typing in values to be "looked up"
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. |
#2
|
|||
|
|||
Sounds like you are typing it in incorrectly. Maybe you are adding a space
somewhere. -- HTH RP (remove nothere from the email address if mailing direct) "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. |
#3
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP: type or paste values | Excel Worksheet Functions | |||
a VLOOKUP quirk | Excel Worksheet Functions | |||
Excel crashing when typing VLOOKUP | Excel Discussion (Misc queries) | |||
Excel 2003 - referenceing the active worksheet page in vlookup | Excel Worksheet Functions |