Get value from cell to other sheet based on condition

[notbanme]

Get value from cell to other sheet based on condition

Hello,
i have sheet with lot of data . i want to get some value of my sheet to other sheet in excel . for ex:

Cell A | Cell B 
==============
AB     |499
-------------------------
CD1   |399
----------------------
JK     |233
------------------------
AB    | 499
-------------------------
CD1  |399
----------------------
JK    |233

this is my sheet with data now i want to get the column B data in my other sheet for ex:

Cell A | Cell B
==============
AB   |499
-------------------------
CD1 | 399
----------------------
JK   | 233
------------------------

[Glenn Kennedy]

Instead of posting these very poorly formatted "Tables", will you instead please attach a sample Excel workbook? Please don't attach a picture of one.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[notbanme]

any solutions ??

[notbanme]

ok i dont do this next time ....

[notbanme]

can you please explain it , thanks

[Crispy85]

Cant you solve this with VLOOKUP?

[notbanme]

its show error , here is the formula i enter " =Vlookup(B2;Sheet3!N:S;2;0) " thanks

[Crispy85]

Put in file B this formula in column B =Vlookup(A2;File A!A:B;2;0)

Change "File A" in the formula to the name of the sheet with all the data.

[notbanme]

image url : https://snag.gy/tw0iSY.jpg

here is attachment link : http://www.excelforum.com/attachment...1&d=1475066063

[Crispy85]

Please attach a sample workbook

[Glenn Kennedy]

Is this what you want? These are all array formulae. Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly braces yourself - it won't work...

if it is NOT what you want, please re-read Post 2, Point 2.