Dear all
My vlookup command gives me #N/A. My vlook up variable is 149441MaxiTRANS Industries Ltd38047 and it is available in the dataset 149441MaxiTRANS Industries Ltd38047. Can you please advice me where it went wrong.
=VLOOKUP(E2,'[M&A without Insider Trading_Parent company details.xlsx]Insider trading database'!$A$4:$AJ$3132,33,0)
Thanks
Shams
Last edited by mahershams; 11-28-2013 at 03:32 AM. Reason: upload file
Hi vlookup excel is attached.
Hi, mahershams,
item has to be found in the first column of the search matrix (in your sample that should be Column E, not A). If itīs located in another column than the first one use Index/Match instead of VLookup.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi HahoBe
May be I did not get you. When I use E4 instead of A4, now it shows #REF!
Please suggest me.
Regards
Shams
Hi Hahobe
Does it mean that vlookup could not able to retrieve the data without match function. Would you be able to advice me?
Hello mahershams,
Pls find the attached file.
I think we can get answer using iferror, index,match
Hi, Shams,
Formula:
Please Login or Register to view this content.
for Sheet2 Range P2.
Ciao,
Holger
Last edited by HaHoBe; 11-28-2013 at 04:07 AM. Reason: edited formula to show english version
Hi Ciao
I have no idea why your or mine vlookup command do not work. However the solution provided by Brandedadnan is retrieving the data successfully.
However thanks for your effort.
Regards
Shams
Hi Brandedadnan
Thank you very for your solution. But if you have time please explain why vlookup unable to retrieve the data.
Regards
Shams
Hi, Shams,
Altered formula for P2:I have no idea why your or mine vlookup command do not work
Formula:Please Login or Register to view this content.
Have a look at the attachment - works fine for me.
Ciao,
Holger.
Hi
Holger
Thank you very much. It works now. I have put wrong index column.
Regards
Shams
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks