Hi Folks
I have attached a Workbook to explain my requirement
Cheers
hammer
Hi Folks
I have attached a Workbook to explain my requirement
Cheers
hammer
Hi
Formula:Please Login or Register to view this content.
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
☚ Click ★ just below left if it helps, Boo?ath?
Try this
=INDEX(Selections!C$2:C$9,MATCH(A5,Selections!$B$2:$B$9,0))
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you!
Here's another one...
=IFERROR(VLOOKUP(A5,Selections!B$2:C$9,2,0),"")
Copy down as needed.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks