Take a look at the worksheet function VLOOKUP() which searches for a value in
the first column of a table array and returns a value in the same row from
another column in the table array.

Syntax is
=VLOOKUP(lookup_value,table_array,col_index_num,ra nge_lookup)

OR
=VLOOKUP(A1,Shee2!A1:D100,4,0)
(This formula if applied in Sheet1 cell B1 will search the value of Sheet1
A1 in Sheet2 A1:A100 and returns the matching value from Column D (4) of
sheet2)


If this post helps click Yes
---------------
Jacob Skaria


"Angie G." wrote:

Can someone help?

I have a workbook with 2 spreadsheets. 1 sheet is data and the other is the
report.

Both sheets have Rig no., Income and Expense Columns. I want a formula in
the report spreadsheet, to go to data spreadsheet and get corresponding
Income and/or Expense amount to corresponding Rig no; because same rig no.
may be listed several times on the report spreadsheet.

Thanks,