Hlookup is a horizontal reference and you're table array argument is using a vertical reference. Try changing the All!G:T part of your equation to something like this All!10:40.
Hlookup is a horizontal reference and you're table array argument is using a vertical reference. Try changing the All!G:T part of your equation to something like this All!10:40.
Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.
Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks