Link to home
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




ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of ADRIANA P

ASKER

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

User generated image


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?
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.

User generated image

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



That error is happening because cell B6582 somehow got changed to "yo no te doijde". I'm working on the 10 below problem.
I understand sometimes I'm typing and the cursor jumps around

thanks for identifying it
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Much Better !!

Great Job best Expert!