Google Drive Calc -  Search for a value on a column return value other column

apocalip30
apocalip30 used Ask the Experts™
on
Hi,

I am trying to make a function (lookup or vlookup) in google drive calc that could search for a value on a column and if it find it return other value.
As in the test file atached  I would like to enter a value on J2 cell , to look for this value on range f2:f45 and if finded return the correspond value on range A2:A45.

Thank you !!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
Hi,

pls try

=INDEX(A2:A45,MATCH(J2,F2:F45,0))

Open in new window

Regards

Author

Commented:
Thanks ! Works Great, I have another question, but i don't know if  that will have to go on a separate one.

For column  ORDEN is there any  formula to assing the same number to ORDEN for each equal Ordernumber as in this example?
That is ORDEN 1 for all repetied order 200001195
ORDEN 2 for all repeted order 200001198

ORDEN      Ordernumber
1      200001195
1      200001195
1      200001195
2      200001198
2      200001198
3      100005020
3      100005020
3      100005020
3      100005020

Thanks again
Top Expert 2016

Commented:
Could you open a new question?

Author

Commented:
Great and quick, Thanks !!

Author

Commented:
Hi Rgonzo

I have also a question related with this to improve the excel sheet, "Google Drive Calc -  Search for a value on a column return value other column, and mark one finded"
¿could you have a look please? thank you

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial