I'm trying to do a Vlookup that picks a table name from a cell.
The formula below works, but i want "FlangeTables" to be the value of B11 of my current sheet. the library wookbook has all my data tables in it and I want to pick the table. The tables all have the same column headers and are aligned horizontally. if i manually type the table name in it works, I just can't get it to look to a cell for the name.
=VLOOKUP(T,'Library.xlsm'!FlangeTables,MATCH(Rating,'Library.xlsm'!FRating),0)
Sounds like you are looking for
Formula:
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks... I had tried it but i must have missed something.. I cut and pasted your's into the cell and it worked.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks