Hi All
I had the same problem a few days ago, which was resolved by Norie...I made a silly mistake. Now, I know I am not being stupid, but seriously this is basics but I can't get it right....
I have uploaded a sample file....My vlookup is not working with the Table
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Hi,
The Combobox defaults to a string value however your lookup table has numerics in column A, so instead use code like:
Please Login or Register to view this content.
Last edited by Richard Buttrey; 04-01-2017 at 01:54 PM.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Hi Richard
Wow, seriously!!! Learn't something new today. Would never have known about default of combobox...Thanks so much. Any way how this line can be replaced with code for Table
Please Login or Register to view this content.
Just substitute the A1 range reference with the name of that range, i.e. Table1.
Please Login or Register to view this content.
Fantastic thanx Richard.
My pleasure and glad to have helped.Originally Posted by sintek
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks