IF and VLOOKUP Help

[JSO]

I am trying to parse out a time-sheet that contains a value in a cell that needs to be placed in one of two columns depending on the code in the prior column.
The codes are in column "I" and the values are in column "J". I would like to build a sheet that adds two additional columns that would allow me to add the value to the appropriate column. If column "I" contains any one of any of the following codes; REIMB, SAL, VAC then i need the value of cell "J2" to be placed in this cell.

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this (copied down) what you mean? If not, more details & examples please.

Book1
	I	J	K
2	REIMB	Data 1	Data 1
3	ABC	Data 2
4	VAC	Data 3	Data 3
5
6	XYZ	Data 5
7	SAL	Data 6	Data 6
To column

Cell Formulas
Range	Formula
K2:K7	K2	=IF(OR(I2={"REIMB","SAL","VAC"}),J2,"")

 

[JSO]

The first shot is the source page and the second is the desired second page. I need to have formulas fro the destination page for the Amount and Hours columns that reads the code in column I on the source page to return the value. Everything but REG should populate the Amount column in the second page and the REG code should populate the Hours column.

 

[snjpverma]

Enter the below in J2 and copy down.

=IF(I2="REG",,H2)

Enter the below in K2 and copy down.
=IF(I2="REG",H2,)

 

[JSO]

I also need the other columns to return the value based on the additional criteria, VAC, PERD, BON, PRO, ADJ etc....

 

[JSO]

So, none of these solutions are working.

Column I can contain any one of 7 variables, all text. Depending on that label, the data in column J needs to be dropped into one of two columns on the second worksheet with the other column returning either a zero or nothing at all.

 

[JSO]

IFS is working for multiple variables, but is not returning just the search criteria linked data.

 

[Peter_SSs]

From my reading of post 3, snjpverma's suggestion in post 4 does just what you asked apart from referencing the appropriate cell on the source sheet. I have also adjusted to show nothing ("") rather than 0 for the irrelevant cells.

BTW, if you want to see the results with your own sample data, you need to give it to us in a form that we can copy/paste to test with, otherwise too much typing is required.
See my signature block below for help with that.

Book1
	I	J
1	Type	Hrs or Amt
2	ABC	10
3	VAC	20
4	REG	30
5	XYZ	52
6	SAL	12
7	REG	45
8	PERD	12
Source

Book1
	I	J	K
1	Type	Amount	Hours
2	ABC	10
3	VAC	20
4	REG		30
5	XYZ	52
6	SAL	12
7	REG		45
8	PERD	12
Destination

Cell Formulas
Range	Formula
J2:J8	J2	=IF(I2="REG","",Source!J2)
K2:K8	K2	=IF(I2="REG",Source!J2,"")