Hi, I thought I understood HLOOKUP's until this happened! The attachment is a sample of what I'm doing, use named range for the HLOOKUP, ComboBox for the dropdown and all it should do is provide an answer in cell S5 based on the dropdown (linked cell is G1).
Fod SOME of the dropdown options it works perfectly but for others it produces random results? Any suggestions would be appreciated.
Thanks for your time
Hi, Try this
Formula:
Please Login or Register to view this content.
☚ Click ★ just below left if it helps, Boo?ath?
Hi
INDEX & MATCH is more flexible. In S5 and copy down try this.
Formula:Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks