gather information from another sheet with one related value

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
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.
 
Thank you very much, it worked!

Sri said:
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
Click to expand...
 
Back
Top