Need Help: Update columns in two excel sheet

[cyberdony2k]

Hello,

I have two excel sheets with two column names (email, status) on both. I want to update status column on second sheet with status columns on first sheet(only if e-mail matches on both).



Please help in writing a formula for same.

 

[Fishboy]

Hello,

I have two excel sheets with two column names (email, status) on both. I want to update status column on second sheet with status columns on first sheet(only if e-mail matches on both).



Please help in writing a formula for same.

Hi cyberdony2k, welcome to the boards.

Based on your description, and assuming that the email addresses are in column A of both sheets (starting in A1) and the status is in column B of both sheets (starting in B1), try the following formula and drag-fill it down your list:

=IFERROR(INDEX(Sheet1!$B$1:$B$100,MATCH(Sheet2!A1,Sheet1!$A$1:$A$100,0)),"")

Sheet1 is the one you are looking the statuses up from.
Sheet2 is the sheet you put the formula in.

If these are actually meant to be the other way around, simply swap the sheet names around in the formula.

 

[cyberdony2k]

Hello Fishboy,

Thanks a lot. Your formula solved my problem.

 

[Fishboy]

Hello Fishboy,

Thanks a lot. Your formula solved my problem.

No problem, happy to help