I currently have two data validated cells (H2 & H3) which will determine the lookup values across a small range A1:C9 and then return a value to H4. Can a Lookup have more than one value?
I currently have two data validated cells (H2 & H3) which will determine the lookup values across a small range A1:C9 and then return a value to H4. Can a Lookup have more than one value?
Last edited by Aussiebear; 05-14-2025 at 07:33 PM.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Ted, this ARRAY formula does it
=INDEX(C:C,MATCH(1,($A$1:$A$20=$H$2)*($B$2:$B$20=$H$3),0))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
being an array, I'll need to enter it with Ctrl,Shift,Enter?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Correct.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
