how can i match the value in other sheet and update the status

[Pakkei512]

Story : i am creating a warehouse inventory file to help the clerk to key in the in/out record.

Detail : sheet1=data input, sheet2=every in/out record, sheet3=the status of every items, sheet4=available items. and i had created a button to save the data to sheet2 and sheet3 from sheet1.

Question : if the sheet1 C9 is the item name, and sheet1 C11 is the update status

then sheet3 D:D = items name, sheet3 E:E = items status

How can i match the items name and update the status

Many thanks

 

[SteveO59L]

is the item name unique?

 

[Rickmaurinus]

If in Sheet 1, you have the Item name in C9, you could lookup the update status with:

=VLOOKUP('Sheet1'!C9; 'Sheet 3'!D:E; 2; FALSE).

 

[Pakkei512]

yes, each item name is unique, just like serial number

 

[Pakkei512]

is the item name unique?

yes, each item name is unique, just like serial number