View Full Version : Solved: Vlookup error
tlchan
11-15-2010, 07:54 AM
Hi there,
I have 2 worksheets "Source" and "Record" to compare for matched item in column E. If matched then copy corresponding row item in column B of "source" sheet into column B of "Record" sheet.
I try to use Vlookup to get result in column I of "Record" sheet but with error "N/A". Is it possible using Index and Match ?
Please help.
:bug:
tlchan
11-15-2010, 08:01 AM
Sample workbook attached
kemas
11-15-2010, 11:15 AM
SEE THIS
tlchan
11-16-2010, 07:17 AM
Thanks kemas for your solution.However you had change the column E of "source" sheet to column A to enable Vlookup function.
Is there any alternative way without changing the column?
shrivallabha
11-16-2010, 10:40 AM
Try
=HLOOKUP("Sec No.",Source!B:E,MATCH(Record!E2,Source!E:E,0),0)
Here I am hoping that you are not going to change your column heading!
kemas
11-16-2010, 10:45 AM
put this formula in cell i2 in sheet " record"
and fill it down
=INDEX(Source!$A$2:$G$15;MATCH(E2;Source!$E$2:$E$15;0);2)
=INDEX(Source!$A$2:$G$15;MATCH(E2;Source!$E$2:$E$15;0);2)
austenr
11-16-2010, 11:11 AM
As a word of warning, do not start a new post if your question has not been answered from a previous post. I answered your post yesterday with the exact problem.
tlchan
11-17-2010, 03:45 AM
Dear Austenr
Correct me if I'm wrong. I did have not any previous post of the same problem and outstanding unanswered post.
Thanks to Kemas's solution just meet my objective. At the same note I would like to thanks Shrivallabha for your alternative worked equivalently but on the "Source" sheet instead of "Record" sheet".
Thanks again for all your assistance.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.