PDA

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.