VLookup formula to copy value from certein cell, if two other cell data are equal

**Robot3** · 09-30-2014, 01:31 PM

Hello.
Sory on poor englishe.
I have two excell 2007 woorkbook.
Primjer1.xlsx Primjer2.xlsx
In "Primjer1" in first columns are data which i whant to search within second "Primjer2" woorbok in first columns.
And if ther are same number, then see if in the same row in second column are writen "Geoportal",and if this aru true,then in first woorkbook on the "Stanje_predmeta" colum for that number write "Geoportal" and in the "Mjesto_predmeta" colum for that number write what is in second woorbok under "Mjesto".
Please help if can.
In first woorkbook,data in first colum are entered in "UP/I-361-03/13-10-1" stiyl,and in formula need to search onli last number,which can be up to four digit.
So it will look like this UP/I-361-03/13-10-1234

**boopathiraja** · 09-30-2014, 11:29 PM

Try with the below two formulas

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

**Robot3** · 10-01-2014, 01:23 AM

It put my eror on first part of (A3,4) formula. :S
Can we use this formula which work for my? For remowing first 18 charachters?
Because in workbook,on this colum each time it have 18 charachter.
=RIGHT(A3; LEN(A3)-18)
And after this 18 charachter come number from 1 to 6000-7000.
And this formula yours work onlie if come 4 number i think.:S

**boopathiraja** · 10-01-2014, 02:20 AM

Try

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

**Robot3** · 10-01-2014, 03:42 AM

=VLOOKUP(RIGHT(A3;LEN(A3)-18)*1;[Primjer2.xlsx]Sheet1!$A$1:$C$5;2;0)
Work like a charm.

Onlie put insted "," i put ";", i use 2007 office,so i do no know are in this trobule. Can i put somehav if no values are find,to do nothing? Now it return N/A eror.

**boopathiraja** · 10-01-2014, 05:31 AM

Then try

Formula:

Please Login or Register  to view this content.

**Robot3** · 10-03-2014, 12:18 PM

Thanx a lot.

You are very helpful,and with this i do 3 day work in no time.

Thanx.

VLookup formula to copy value from certein cell, if two other cell data are equal

LinkBack

Thread Tools

Rate This Thread

Display

VLookup formula to copy value from certein cell, if two other cell data are equal

Re: VLookup formula to copy value from certein cell, if two other cell data are equal

Re: VLookup formula to copy value from certein cell, if two other cell data are equal

Re: VLookup formula to copy value from certein cell, if two other cell data are equal

Re: VLookup formula to copy value from certein cell, if two other cell data are equal

Re: VLookup formula to copy value from certein cell, if two other cell data are equal

Re: VLookup formula to copy value from certein cell, if two other cell data are equal

Thread Information

Users Browsing this Thread

Similar Threads

If Cell A is equal to Cell B replace the data from Cell A with Cell C. How can I do this.

[SOLVED] Formula Needed to copy data from a cell based on data entered into another cell

[SOLVED] Copy data with 4 cell interval and copy range of data like vlookup with structured output

[SOLVED] how to do "if formula for cell to equal cell when < or = another cell

macro to copy data where the ID is equal to what is copied from another cell

Bookmarks

Bookmarks

Posting Permissions