• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VLookUp Problem 1

G

GN0001

Member
I do a VLookUp, please see uploaded file.

VLookUp picks up the value, but it doesn't show the picked value in a right cell.
Value 346263 is picked, It has to be shown in column b in front of value 346263 in column a, but it is being shown in front of 351919. Please see the uploaded file.

What is the Problem?

I appreciate your response.

GN0001
 

Attachments

I am looking sheet 2 value in sheet 1.
=VLOOKUP(Sheet2!$A2,Sheet1!A:A,1,FALSE)
This is what I want. I never asked for =VLOOKUP(A2,Sheet2!A:A,1,)
This is a big issue for me. Why VLookUp behaves like this?
Thanks,
GN0001
 
This will happen, as on sheet 2 you have 346263 which it will find on sheet 1 and return the value. This is right?

What actually you want?

Regards,
 
Yes, this is right, as I said before, it brings back the value, but it doesn't bring it back in a right place.
 
I don't want to use an if here. I am going to dig into VLookUp. What you have on the top is totally different from what I mean. I am looking for a value in sheet b in a range in sheet a. You have changed the function. Sorry about it. Thanks
GN0001
 
Kindly go through VLOOKUP help. I think there is a misunderstanding of the function to you.

VLOOKUP look for a value in a table and if found returns a corresponding column value. Now you are looking an employee # from sheet 2 in sheet 1, so it will found it and place in B2 on sheet 1. What is there on sheet1 is lookup table, so it will never happen that it place the value infront of same emp #.

Regards,
 
Somendra,
Fine, I understand it. Then what is the reason when it finds the value in sheet a, it places the value in b2 in sheet 1, why does it not place it in sheet 1 in b3?
Please advise me.
GN0001
 
Dear GN0001,

Position on sheet 1 doesn't really matter here as you are looking a value from sheet 2 in sheet 1. SO if you place this formula in F2 also it will work.

Regards,
 
You must log in or register to reply here.
Back
Top