compare data from 2 sheets

[IKHAN]

Hi, Hope i can explain my issue below, Any help would be really appreciated.


when i copy data or enter data into sheet 1 column A5 ,A6,A7...upto A1000 as REQD., It should check data in sHEET (fIXED) column A and if there is a match of 2 exact same item ,It should fill DATA from Sheet(Fixed) Column B in sheet 1 column G accordingly.


Now the problem - Already running a formula in sheet 1 Coulmn G upto G1000


FORMULA sHEET1 column G :


=IF(A5="","",IF(ISNA(VLOOKUP(A5,'pre input'!A:A,1,FALSE)),"None",IF(RIGHT(A5,1)="B","Second","Prime")))


Have uploaded sample sheet :


Note SHEET1 : cOLUMN A Marble sholud give output Column G - Agra and cOLUMN A STONE sholud give output Column G - JAIPUR


https://hotfile.com/dl/224714275/bdf0677/sheet_compare.xlsx.html

 

[IKHAN]

Can i get help on this Please???

 

[Hui]

Ikhan


Sheet1!G11 =IF(A11="","",VLOOKUP(A11,fixed!A:B,2,FALSE))

Copy down

 

[IKHAN]

Hi Hui, As mentioned in previous post , have a formula already running in SHEET1 G :G1000 for other query


=IF(A5="","",IF(ISNA(VLOOKUP(A5,'pre input'!A:A,1,FALSE)),"None",IF(RIGHT(A5,1)="B","Second","Prime")))


Need additional formula in sheet1 g: g1000 to check both instances

 

[SirJB7]

Hi, IKHAN!

Which one of the two conditions should prevail? That of pre-input or that of fixed?

Regards!

 

[IKHAN]

hi SirJB7,


Both conditions should prevail...if data in fixed sheet exists, it should capture overriding data in pre-input

 

[SirJB7]

Hi, IKHAN!


Not both, that's not possible, as you wrote fixed prevails over pre-input. Try this:

=SI(A5="";"";SI(ESNOD(BUSCARV(A5;fixed!A:B;2;FALSO));SI(ESNOD(BUSCARV(A5;'pre input'!A:A;1;FALSO));"None";SI(DERECHA(A5;1)="B";"Second";"Prime"));BUSCARV(A5;fixed!A:B;2;FALSO))) -----> in english: =IF(A5="","",IF(ISNA(VLOOKUP(A5,fixed!A:B,2,FALSE)),IF(ISNA(VLOOKUP(A5,'pre input'!A:A,1,FALSE)),"None",IF(RIGHT(A5,1)="B","Second","Prime")),VLOOKUP(A5,fixed!A:B,2,FALSE)))


Regards!

 

[IKHAN]

Aha...It works...thank u so much...SirJB7

 

[SirJB7]

Hi, IKHAN!

Glad you solved it. Thanks for your feedback and welcome back whenever needed or wanted.

Regards!