LinkBack URL
About LinkBacks
Hi expert ,
If Column E in Book1 matches Column B in Book2 Then place the value from column A of Book1 in Book2.
I need a formula for this ..
Please help me
Thanks,
Book1.xlsxBook2.xlsx
Hi expert ,
If Column E in Book1 matches Column B in Book2 Then place the value from column A of Book1 in Book2.
I need a formula for this ..
Please help me
Thanks,
Book1.xlsxBook2.xlsx
Last edited by Cutter; 07-22-2012 at 10:49 AM. Reason: Corrected title
in [Book2.xlsx]Sheet1!A2:
=IFERROR(INDEX([Book1.xlsx]Sheet1!$A$2:$A$8,MATCH($B2,[Book1.xlsx]Sheet1!$E$2:$E$8,0)),"-")
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
Thanks icestationzbra , perfect .
@ sqlindia
Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself.
Thanks.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Thanks Cutter, As a new member I'm not aware of marking it as solved. I will definitely in future.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks