Hi
Thought I had vlookup figured.
This is what I used
=VLOOKUP(B3,DataM,12,o)
This is in third column (C)
Column B is where I put item code
DataM is data range I selected and named from a sheet next to this sheet
12 is the column # from that data range
o is because it is text
I have #name? shows in the cell
What am I doing wrong?
Tia
Hi Tia,
I think the "o" needs to be a "False" or "Zero". That means you want the lookup to be an EXACT match.
See http://www.contextures.com/xlFunctions02.html if I'm way off base.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
OK Tks
Tried that
Now I have #N/A in Column c
Does that mean that datam is not being recognized?
Doobers..!!!!
Do you have 12 columns worth of data in your Named Range called DataM?
Do you have the exact same spelling of what is in B3 in the left most column of the DataM range?
Can you post a sample of your data if the above doesn't work? To do that... click on the "Go Advanced" below the message area and then on the Paper Clip Icon above the advanced message ares.
I have 13 columns
Does Column B have to be associated with or linked to DataM? The item codes are in columnA in DataM
Does upper/lower case matter?
There is private data in datam ph#s , names addresses so I do not want to post any of it.
If it helps The page the formula and table I am working on is a sheet called Print and the data is on sheet called Master.
OK read a little closer B3 and the Formula is on sheet print
Datam is data from sheet master.
Here is what I am working on
Temp1.xlsx
That is the sheet called print.
Lower case doesn't matter.
Try a YouTube search using VLookup Tutorial 2010. As soon as you find the problem it will all come clear. Sorry I can't help much more without a sample.
without having access to actual data
this is the best we can do for you
attached is your sample with DataM named range internally in sheet "Master"
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
in this case may be value you are searching for is not available in 12th column of DataM
I think I may have found problem, not sure.
When I created datam I just highlighted columns at the top so titles and joined cells at top are included.
But How do you delete/reset/redo datam? OK found out how
The Temp file you sent me is the same as I have but still will not work. Thats what got me thinking it might be datam.
Last edited by jazz56; 06-14-2013 at 12:12 PM.
OK Solved part of problem. When Column B is empty I get #N/A in column C (value not available for error)
Do I have to have a blank row in Datam?
OK I tried inserting blank row in datam and still get error.
Temp2.xlsx
Last edited by jazz56; 06-14-2013 at 01:33 PM.
This is how my sheet looks with nothing in Column b (the item code)
Code Name City Prov. Citizenship Gender Date of Birth Ph#
1 #N/A #N/A #N/A #N/A #N/A #N/A #N/A
2 #N/A #N/A #N/A #N/A #N/A #N/A #N/A
3 #N/A #N/A #N/A #N/A #N/A #N/A #N/A
4 #N/A #N/A #N/A #N/A #N/A #N/A #N/A
5 #N/A #N/A #N/A #N/A #N/A #N/A #N/A
6 #N/A #N/A #N/A #N/A #N/A #N/A #N/A
If an item is in code
it looks like this
Code Name City Prov. Citizenship Gender Date of Birth Ph#
1 test Test , Ted Home BC Can Male Jan, 1, 2013 555 555 1212
2 #N/A #N/A #N/A #N/A #N/A #N/A #N/A
3 #N/A #N/A #N/A #N/A #N/A #N/A #N/A
4 #N/A #N/A #N/A #N/A #N/A #N/A #N/A
this will make cell "" if the cell is #N/A
Please Login or Register to view this content.
Perfect Thank You
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks