Looking up same value and returning location

[Closed]
Report
Posts
1
Registration date
Tuesday November 1, 2016
Status
Member
Last seen
November 1, 2016
-
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