Hello. I have a sheet where I've put lookup values to the left of my vlookup formulas. Unfortunately, there are a lot of helper rows and I don't want to have to create a vlookup that's different depending on the numbers to the left for each cell. Is there a way I can write vba (or just regular excel) that will automatically create the vlookups for each cell? Spreadsheet attached.
Doing a vlookup with multiple search criteria will give an error.
What are you trying to achieve? Maybe you can also post the table you want to search?
Cheers!
Tsjallie
--------
If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!
If you think design is an expensive waste of time, try doing without ...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks