Having one drop down cell to show two columns of data

[PEAKCAB]

Help please

I have a invoice prepared and i am looking to have a part number from a drop down list but then want show in another column the description generated by the part number.

Any help would be greatly appreciated

Regards,

 

[PEAKCAB]

All sorted - must have been a slip of the finger!

Another question sorry! I have copied down the cell as per your mail; if the part no. column is empty the description cell shows #n/a, is there a way of showing a blank cell if there is nothing in the part no. column?

Rich

 

[Yongle]

wrap inside IFERROR

=IFERROR(VLOOKUP(A27,Product!A:B,2,0),"")

 

[PEAKCAB]

Thank you so so much for helping with this. Very much appreciated

Regards,

Rich