Excel 2007 : Completing a form automatically based on several inputs and conditions

I hope I am posting this within the correct forum. I really need help with figuring out how to perform the below described function within my spreadsheet. I hope you guys can help me and sorry if I didn't place this in the right thread.

The part number of the rma testing sheet will be scanned with part number bar codes I created. Then if it is a scanned item within the list under data list: Models to China. Then the next section, received status, needs to auto fill with Ship Back to China. Then if that is what is automatically selected. Then the next one, testing status, will need to auto fill with NO TEST. Also if the Received status is selected to “New to Restock”. Then the testing status will also have to have No Test. Ideally, also, if the Part number is one pulled from the Refurbished listing then the received status will need to auto-select refurbished with testing status not being filled. They all need to be able to accept manual changes too.

RMA Testing Form.xlsx

Originally Posted by SteveMCrow

I hope I am posting this within the correct forum. I really need help with figuring out how to perform the below described function within my spreadsheet. I hope you guys can help me and sorry if I didn't place this in the right thread.

The part number of the rma testing sheet will be scanned with part number bar codes I created. Then if it is a scanned item within the list under data list: Models to China. Then the next section, received status, needs to auto fill with Ship Back to China. Then if that is what is automatically selected. Then the next one, testing status, will need to auto fill with NO TEST. Also if the Received status is selected to “New to Restock”. Then the testing status will also have to have No Test. Ideally, also, if the Part number is one pulled from the Refurbished listing then the received status will need to auto-select refurbished with testing status not being filled. They all need to be able to accept manual changes too.

Attachment 137407

Dear Steve

I am not an expert like these other guys but whenever I hear someone say the words autofill a cell based on a list. I immediately thing this is a job for (drumroll) Vlookup function.
VLOOKUP
I know this is not an attached worksheet solution but hope it at least provides a strating point. If you get stuck get back here.

Take care and all the best