Looking up same value and returning location

Closed
SIRINIL Posts 1 Registration date Tuesday November 1, 2016 Status Member Last seen November 1, 2016 - Nov 1, 2016 at 04:25 PM
can i look up the same value in 2 separate spreadsheet and return the location?

Spreadsheet 1
A- item number
B item description
Spreadsheet 2
A- item description

would like to have return the location of the matching description if possible if not the item number
Thank you