gather information from another sheet with one related value

[Guest]

I have a workbook with two worksheets. Each sheet is getting it's data from
a different source. Sheet 3 was exported from access and sheet two is from
another workbook. There is one value (per record) that relates the 2 sheets
and I need to bring information from the related value row to the second
sheet.
I have: =MATCH(B3,Sheet3!A:A,0) In cell M3 of sheet 2, this has given me
the row number of the record from sheet 3. Which is (10)

then I: =ADDRESS(M3,2,1) In cell N3 of worksheet 2, this has given me the
cell address. Which is (B$10$)

How can I get the value from the cell address (B$10$), sheet 3 to be entered
on sheet 2? I need to drag the formula's for 140 records, so I need the
matching value to be looked up and than gather the info from that row. Help!

 

[Guest]

Use VLookup instead of Match to get the value from Sheet3

= Vlookup(B3,Sheet3!A:A,1,0)
where 1 represents the column from where the data will be picked if value is
found. Change the range and the required column as per your need.

 

[Dave Peterson]

=vlookup(b3,sheet3!a:b,2,false)
or
=index(b:b,match(b3,sheet3!a:a,0))

Debra Dalgleish has some notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

 

[Guest]

It worked - thank you very much! =vlookup(b3,sheet3!a:b,2,false)

 

[Guest]

Thank you very much, it worked!

Use VLookup instead of Match to get the value from Sheet3

= Vlookup(B3,Sheet3!A:A,1,0)
where 1 represents the column from where the data will be picked if value is
found. Change the range and the required column as per your need.

--

Regards

Sri