I'm trying to return some values from one worksheet to another . I tried using both Vlookup & indexmatch . None of them seems to be working for me .I have attached the spreadsheet for the reference . Thanks in advance !
In Rawdata worksheet , Column Z has " vlookup " & Column " AA" has Index match
I would also like to know whats causing this problem , because this happens for me most of the times .. Am I using incorrect data type ?
no attachment... try again?
Without seeing the workbook, it's impossible to know for certain, but my first thought is that the lookup values are not quite the same. "Chicago" and "Chicago " are not equivalent in Excel, for example. Check lookup list and lookup values to make sure that one of them doesn't have trailing spaces. hth
You may also be looking up numbers stored as text against numbers stored as numbers (or vice versa) - that's another common issue.
Remember what the dormouse said
Feed your head
Oops , I didn't notice that spreadsheet was not attached properly . Thanks for your responses . Here we go with the attachment
Your Master data appears to have a maximum of 6 characters whereas the data you are looking up can have more. Try using:
=VLOOKUP(RIGHT(B2,6),Master!A:B,2,0)
but note that not all of the data matches anyway.
Not all cells are returned with the above formale .
As I said, not all of them have a match. Can you give me an example of one you think should match, but doesn't?
look at your emplyee number on raw data compared to master page,,, on raw data the numbers start with 00 zero zero.
in fact, go through your info, try ctrl & f on your master sheet for some numbers you are looking to use in vlookup, they are not found.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks