Urg excel formula pls

[DBgirl]

I have 2 active sheets.

First active sheet has order 5 numbers 

Second actice sheets has 10 numbers.

Along with date.

Need a forumla to search sheet 1 number in sheet 2  and see column b in sheet 2 i.e. order date and return in sheet 1 next to order. Any quick inputs pls.

[kathanayaka]

try VLOOKUP

[DBgirl]

Just now, kathanayaka said:

try VLOOKUP

Logic ivu ba

[dasari]

3 minutes ago, DBgirl said:

I have 2 active sheets.

First active sheet has order 5 numbers 

Second actice sheets has 10 numbers.

Along with date.

Need a forumla to search sheet 1 number in sheet 2  and see column b in sheet 2 i.e. order date and return in sheet 1 next to order. Any quick inputs pls.

First define names to those lists...apply vlookup

[LazyRohit]

pagavadiki kuda rakudadu e @whatsapp gani kashtalu

[MagaMaharaju]

3 minutes ago, DBgirl said:

Logic ivu ba

Syntax 

=VLOOKUP (value, table, col_index, [range_lookup])

Arguments 

• value - The value to look for in the first column of a table.
• table - The table from which to retrieve a value.
• col_index - The column in the table from which to retrieve a value.
• range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.

[kathanayaka]

see this...pulling from 2 shets in same workbook

 

https://www.ablebits.com/office-addins-blog/2014/07/17/excel-vlookup-tutorial-beginner/

[kuduvu]

index match is more accurate than vlookup

[DBgirl]

8 minutes ago, kathanayaka said:

see this...pulling from 2 shets in same workbook

 

https://www.ablebits.com/office-addins-blog/2014/07/17/excel-vlookup-tutorial-beginner/

Thank you bro looking at this

[DBgirl]

10 minutes ago, LazyRohit said:

pagavadiki kuda rakudadu e @whatsapp gani kashtalu

Avuna ra bahi inthaiki vadiki yem kastam vachindhi uncle

[DBgirl]

13 minutes ago, kuduvu said:

index match is more accurate than vlookup

Bro please excel lo logic ivvu late avuthundi

[LazyRohit]

6 minutes ago, DBgirl said:

Avuna ra bahi inthaiki vadiki yem kastam vachindhi uncle

oka ammayi hand icchindi inka vadiki hand a gathi ayyindi ani agraharam lo talk nadustundi

[kuduvu]

1 minute ago, DBgirl said:

Bro please excel lo logic ivvu late avuthundi

https://www.ablebits.com/office-addins-blog/2014/08/13/excel-index-match-function-vlookup/

[DBgirl]

4 minutes ago, LazyRohit said:

oka ammayi hand icchindi inka vadiki hand a gathi ayyindi ani agraharam lo talk nadustundi

Are 10gay ra ikada time ledu.

[LazyRohit]

3 minutes ago, DBgirl said:

Are 10gay ra ikada time ledu.

cool ra @whatsapp