Is there an easy way to expand this formula, say to z
Regards TroysiePlease Login or Register to view this content.
Is there an easy way to expand this formula, say to z
Regards TroysiePlease Login or Register to view this content.
Try this...
Formula:Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Try this instead:
=HLOOKUP(J4,K$1:Z$2,2,0)
Hope this helps.
Pete
=hlookup(j4,$k$1:$ax$2,2,false)
Elegant Simplicity............. Not Always
Thank you to all
Regards Troysie
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks