Thread: How can the merge the two cells data in a Single sheet....

Hi...everybody,

i have a work book it contains 3 sheets, one contains item code and description,another one itemcode and locator, 3rd one is master sheet,it contains Item code and Min, Max. that means item code is similar in all sheets. now i like to merge sheet-1 (description) and sheet2 locator with master sheet(sheet-3)

please have a look in to my attached file and help me.

Hi,

In D2 and copied down,
=INDEX(Sheet3!$B$2:$B$101,MATCH(Master!A2,Sheet3!$A$2:$A$101,0))

and in E2 and copied down
=INDEX(Sheet2!$C$2:$C$101,MATCH(Master!A2,Sheet2!$A$2:$A$101,0))

D2: =VLOOKUP($A2,Sheet3!$A:$B,2,FALSE)
E2: =VLOOKUP($A2,Sheet2!$A:$C,3,FALSE)

And copy down to the end of the list.


Regards, TMS

thank u guys.

really i liked ur answers..its really remarkable.
now i have one more problem. i have 3 sheets same like before. but sheet1 and sheet2 is a data entry sheet.2 staffs are updating separate sheets. but i like to merge sheet1 and sheet2 with my master sheet. here also item code is same.

have a look into attached file...

It's basically the same as before:


=VLOOKUP($A2,Sheet2!$A:$C,3,FALSE)


Regards, TMS

thank you. but as per ur above formula i can get only sheet 2 locator only..how can i get sheet3 locator in master sheet? now sheet3 locator showing error in master sheet.

please

Change Sheet2 to Sheet3?

no...no...you didnt get my point. i mean to say i cant put cretiera range both sheet?
eg- =VLOOKUP($A2,Sheet2!$A:$C&Sheet3!$A:$C&,,3,FALSE)

Ah, sorry, no, you can't do that. At least, as far as I know.

You could try the VLOOKUP against Sheet2 and, if that failed, try against Sheet3

=IFERROR(VLOOKUP($A2,Sheet2!$A:$C,3,FALSE),IFERROR(VLOOKUP($A2,Sheet3!$A:$C,3,FALSE),"Not Found"))


Regards, TMS

wow....awesome formulaa...thank you...

if master sheet A2 contains item description in stead of Item Code..i can use same formula?

Well, not exactly because you'd be using a different column for the search column and you'd be returning data from a different column. But the principle is the same so you should be able to work it out.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

thank you.....
god bless u..