Hello,
I am having some issues with a userform derived vlookup
I have the code below pulling from a textbox named TextBox1 and doing index matches off of it to then put the summary info in a messagebox
I keep getting a "Unable to get the Match property of the worsheetfunction class" error message on the formula lines
does someone know what is wrong with it?
Please Login or Register to view this content.
Thanks
We need to see the workbook.
ViewPic.
Click the * Add Reputation button in the lower left hand corner of this post to say thanks.
Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.
I can't test this because I have nothing to test it with. However, if it were me, I'd write it like this given that a) you are using worksheet functions and b) you are using the MATCH several times.
Please Login or Register to view this content.
It's not so repetitive, it's easier to read, it isolates the Match, and you can, therefore, test the value returned.
To investigate further, I would need a sample workbook with some typical data and all the code.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hello,
Thank you for the response
please find attached the file
I must be doing something wrong, I have this lookup going both ways (two text boxes and two submit buttons to look up column A in G and vice versa but one of them works and the other gives an error
lookup tool.xlsm
The values in text boxes are returned as text. So for example your ICD-9 values in column A are numbers, so you need to change the text box output to a number. You can use Val.
CommandButton7 code:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks