Solved

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

Posted on 2016-08-03
36 Views
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 !!
0
Question by:apocalip30
• 3
• 2

LVL 48

Accepted Solution

Rgonzo1971 earned 500 total points
ID: 41740363
Hi,

pls try

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

Author Comment

ID: 41740375
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
0

LVL 48

Expert Comment

ID: 41740384
Could you open a new question?
0

Author Closing Comment

ID: 41740393
Great and quick, Thanks !!
0

Author Comment

ID: 41743745
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
0

## Featured Post

Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.