VB Script to lookup data in one sheet and fill in another sheet

[Ram kumar]

Hello Friends,

I have an excel workbook with two sheets. The first sheet is Sheet A and the second sheet is Sheet B. I have some data in Sheet B in three columns and some data in Sheet A. Can I get a code to fill the data in sheet A by checking the data in Sheet B.

Please check the excel file for details.

Thank you

 

[vletm]

Ram kumar
Something like this after click [chk B]-button in cell[S1]?

 

[Ram kumar]

Ram kumar
Something like this after click [chk B]-button in cell[S1]?

Dear Vletm,

Thanks a ton. That is exactly what I am looking for.

Thanks a lot again

Regards
B Ram kumar

 

[shrivallabha]

FWIW, a formula solution will also work. In cell C6:
=LOOKUP(2,SEARCH($B6&C$1&$A6,'Sheet B'!$A$1:$A$64&'Sheet B'!$B$1:$B$64&'Sheet B'!$C$1:$C$64,1),'Sheet B'!$D$1:$D$64)
copy in all yellow cells afterwards.

 

[Ram kumar]

FWIW, a formula solution will also work. In cell C6:
=LOOKUP(2,SEARCH($B6&C$1&$A6,'Sheet B'!$A$1:$A$64&'Sheet B'!$B$1:$B$64&'Sheet B'!$C$1:$C$64,1),'Sheet B'!$D$1:$D$64)
copy in all yellow cells afterwards.

Hello Shrivallabha,

Thank you for the formula, I have a small question. what does "2" indicate in the formula in =lookup(2

Regards
Ram kumar

 

[shrivallabha]

This particular construct has been around for some time now. See this old thread on MrExcel:
https://www.mrexcel.com/forum/excel-questions/99621-lookup-value-unsorted-data.html

Go through it and come back if you still have questions.

 

[Ram kumar]

This particular construct has been around for some time now. See this old thread on MrExcel:
https://www.mrexcel.com/forum/excel-questions/99621-lookup-value-unsorted-data.html

Go through it and come back if you still have questions.

Thank you, it clear now .