I have played around with a bunch of search functions, but I keep falling short. I think this is an easy question, but I am just at my end of my capabilities.
I have raw data in a sheet1 called "pulled". Then a sheet2 called "pay".
The end result I need is a formula in the "pay" tab of Sheet1 to show the pay for a particular item under the B column. For example, the formula in B2 would equal $3. The formula in B5 would equal $7.
The challenge I have is the data in the sheet1 A2:A5 will always vary with years and models, but the ending names (part types) will always match the data in the sheet2 pay.
Basically, I need to have a formula that looks at the data in sheet1 A column, searches the text in sheet2 A column and return the value in sheet 1 B column.
Sheet1 (PULLED)
<tbody>
</tbody>
<tbody>
</tbody>
I have raw data in a sheet1 called "pulled". Then a sheet2 called "pay".
The end result I need is a formula in the "pay" tab of Sheet1 to show the pay for a particular item under the B column. For example, the formula in B2 would equal $3. The formula in B5 would equal $7.
The challenge I have is the data in the sheet1 A2:A5 will always vary with years and models, but the ending names (part types) will always match the data in the sheet2 pay.
Basically, I need to have a formula that looks at the data in sheet1 A column, searches the text in sheet2 A column and return the value in sheet 1 B column.
Sheet1 (PULLED)
<colgroup><col width="327"></colgroup><tbody> </tbody> |
<colgroup><col width="64"></colgroup><tbody> </tbody> | ||
<colgroup><col width="327"></colgroup><tbody> </tbody> | |||
<colgroup><col width="327"></colgroup><tbody> </tbody> | |||
<colgroup><col width="327"></colgroup><tbody> </tbody> |
<tbody>
</tbody>
Sheet2 (Pay)
<tbody> </tbody> |
<tbody>
</tbody>