Matching cells within two spreadsheets, return value from a different cell to another shet

[ladod1424]

I need help with one more thing

I have a spreadsheet with two tabs of information. what I want to do is match cell C2 in my first spreadsheet with sheet 2 cell AD10, they have corresponding numbers. from this point the second spreadsheet column AD10 that value equals the text in cell D10. Cell D10's information is what I need, then place that text in sheet 1 cell D2.

PLEASE HELP

[FDibbins]

Take a look at using the VLOOKUP() function for this. The syntax is...
=VLOOKUP(what-you-want-to-find,range-to-search-in,column-that-contains-the-match,FALSE) FALSE is for finding an exact match

[ladod1424]

Ford,

Thank you for your response and help.

Only one thing. After matching is complete, I want to pull information from a different cell that is in the same row. For example.

Sheet 1 - tblProductlocation - IxtRecord Code.jpgsheet 2 - tblWarehousebin - IxtRecord ID.jpgSheet 2 - tblwarehousebin Description name needed.jpg

In the Product location table, I have a value in C2 which is (111) this is a record ID for a text value that I need to pull from the warehouse bin table in column D and place into D2 of the Product location table.

In the Warehouse bin table, the Description (text value) I need corresponds with (111-record ID). In the same table AD column is where the Record ID exist. I hope I'm explaining this correctly.

I have the Record ID's in the product location table already. Thought that would be useful to match between sheets then pull the Description (text value). But there could be a completely different way to do this.

Hope the pictures help give the visual

[FDibbins]

Please do not upload a picture of your file (especially pics so small that you can hardly even see what is in them)...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)

[ladod1424]

I am sorry about that. I'm going to put it this way hopefully you understand and can help. I have two spreadsheets I want to match row C of my first spreadsheet to row AD of my second spreadsheet. Say cell C1 matches cell AD76 now here is where I am having a hard time, once the two are match in return I want the value of cell D76 of the second spreadsheet.

Basically I want to match row C of the first Spreadsheet and row AD of the second spreadsheet and in return I want the Value of Row D in the second spreadsheet.

[ladod1424]

Okay here is the sample.

In the Product location table, I have a value in C2 which is (111) this is a record ID for a text value that I need to pull from the warehouse bin table in column D and place into D2 of the Product location table.

In the Warehouse bin table, the Description (text value) I need corresponds with (111-record ID). In the same table AD column is where the Record ID exist. I hope I'm explaining this correctly.

I have the Record ID's in the product location table already. Thought that would be useful to match between sheets then pull the Description (text value). But there could be a completely different way to do this.