Hi
I am struggling with a lookup on 2 fronts and need some assistance with this.
a) I want to be able to remove the current #N/A when a cell is left blank. Currently the formula i am using is =LOOKUP(D20,$X$292:$X$303,$Y$292:$Y$303)
b) The table that holds my lookup has values in UPPERCASE however when choosing from a list i am able to key in values in lower case. Is there any way that i can force the value to UPPERCASE?
Appreciate any help with this.
Thanks
Hi
For the first issue try IFERROR(for Excel >2003)
Formula:
Please Login or Register to view this content.
For the second one, not sure..Perhaps if we had a small sample workbook..
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.
a) depends on which version of Excel you are using.
Any version:Formula:Please Login or Register to view this content.
For 2007+:Formula:Please Login or Register to view this content.
b) I think you'd need a VBA worksheet change event to monitor the cells and convert to uppercase.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks