brockmoller
New Member
- Joined
- Sep 3, 2014
- Messages
- 8
I have sheet 1 with one column of values like this:
<tbody>
</tbody>
I have sheet 2 with 2 columns of values like this:
<tbody>
</tbody>
I need to make a column B in sheet 1 that grabs the $ values from column B in sheet 2.
I need a formula to put in column B of sheet 1 that will look up the value "BLINKIN" from column A in sheet 2 and correspond that to the same partial string in sheet 1 (F14BLINKIN-DW contains "BLINKIN") thus giving me $125 in column B of sheet 1.
I have figured out how to do this in reverse (I can get a value from column B in sheet 1 and put that in column C of sheet 2 using this formula):
IF("*"&A4&"*"="","",VLOOKUP("*"&A4&"*",flatfile::Table 1::$A$2:$C$219,2,FALSE))
I need to know how to do this in reverse, basically. Any ideas would be greatly appreciated!! Thank you!!
F14BLINKIN-DW |
F14BRAVE-DW |
F14JORJALG-DW |
<tbody>
</tbody>
I have sheet 2 with 2 columns of values like this:
BLINKIN | $125.00 |
Deeter | $150.00 |
Lucy | $130.00 |
<tbody>
</tbody>
I need to make a column B in sheet 1 that grabs the $ values from column B in sheet 2.
I need a formula to put in column B of sheet 1 that will look up the value "BLINKIN" from column A in sheet 2 and correspond that to the same partial string in sheet 1 (F14BLINKIN-DW contains "BLINKIN") thus giving me $125 in column B of sheet 1.
I have figured out how to do this in reverse (I can get a value from column B in sheet 1 and put that in column C of sheet 2 using this formula):
IF("*"&A4&"*"="","",VLOOKUP("*"&A4&"*",flatfile::Table 1::$A$2:$C$219,2,FALSE))
I need to know how to do this in reverse, basically. Any ideas would be greatly appreciated!! Thank you!!