Avatar of ADRIANA P
ADRIANA PFlag for United States of America asked on

add lookup for range 4n

4n to add userfom range wk

29225036.xlsb


1-add button in CE2 to CH2 call it " RANGELOOKUP"


2-than add userfom  ( same as in ORDFROM Button )


3-columns CG have the key for the subform




Microsoft ExcelVBAMicrosoft Office

Avatar of undefined
Last Comment
ADRIANA P

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
ADRIANA P

Try this. I don't know if you noticed but in previous versions selecting AZ as one of the columns gave #REF! errors in the results for that column. 

sometimes an error appears that says like this




ALSO 
One situation that I have is that I need all the columns to be two above and 10 below the chosen one (the key)
and what is happening is that only BF shows me 2 above and 10 below and the other columns only one below

can it be corrected?
Martin Liss

When you say "sometimes an error appears that says like this" are you referring to the current workbook? If so I need to know the column and key that you were searching for.

Cuando dice "sometimes an error appears that says like this", ¿se refiere al libro de trabajo actual? Si es así, necesito saber la columna y la clave que estaba buscando.
ASKER
ADRIANA P




select column AZ first then the others
I see that if I select it AZ first the error occurs
but it happened to me in other combinations that I don't remember



All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Martin Liss

That error is happening because cell B6582 somehow got changed to "yo no te doijde". I'm working on the 10 below problem.
ASKER
ADRIANA P

I understand sometimes I'm typing and the cursor jumps around

thanks for identifying it
SOLUTION
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
ADRIANA P

Much Better !!

Great Job best Expert!
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.