using 1 cell and datatable too populate 2 cells

Copper Contributor

I am currently going over a previous test I had in excel and on part 2 section A (i) their is a table with date,order,location columns (all populated) and to the right are cells labeled order no,location of order and date of order and I need to able too enter the order number into the order no cell and then the location of order and the date of order cells become populated with the corresponding data on the table but I do not understand how to do this

 

1 Reply

Hi @g00361169 

 

Please the attached file with you query resolved, once enter the Order other information are getting updated

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer.