Hi
Im trying to get specific cell value but failed. What im trying to find is there are these values in sheet one.
Untitled2.jpg
And in sheet two i have to find out if account type is n in cell a2 , match b2 with sheet 1 and check for value next to it and bring it.
lets say if accoutn type is n and came is Car 1, go sheet1 check n first than find car1 and bring the value (2) into added value cell in sheet 2
Untitled.jpg
can u help me about these please ?
Last edited by beetlejuicee; 05-05-2016 at 09:40 AM.
Copy this in cell Sheet2 E2 then drag down.:
If the range of data changes you have to adjust the index and the match ranges accordingly.
Please Login or Register to view this content.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Most forummembers don't want to remake your own file.
you get better help on your question if you add a small excel file, without confidential information.
please also add the expected result in your file.
The solution will be found with index/match/match
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Try this...
=VLOOKUP(B2,Sheet1!A$1:E$6,MATCH(A2,Sheet1!A$1:E$1,0),0)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks