advanced VLookup

[biglb79]

I wasn't sure what subject to use, but I'm hoping I can describe what I'm trying to do and someone can help.

I'm trying to populate a cell in columns AG or AH. It will depend on what the value is during the search.

I want to lookup the value in cell Q3 based on the information on the accrual lookup tables tab columns M:O. the values to match cell Q3 are located in column M. then if column N says Deduction code I want it to populate Cell AH3 with the value in column O on the accrual lookups tab and then have column AG stay blank. if the value in column N says Workday Deduction Code then I want the value to fill cell AG and have AH be blank

basically I'm trying to lookup values in columns AG and AH based on what's in column Q. I want it to use the values in column O on the other tab but decide what column to populate based on column N

I really hope this makes sense and someone can help!

 

[FormR]

Hi,

For AG3 you could try:

=IF(VLOOKUP(Q3,'accrural lookup'!M:O,2,0)="Workday Deduction code",VLOOKUP(Q3,'accrural lookup'!M:O,3,0),"")

And for AH3 you could try:

=IF(VLOOKUP(Q3,'accrural lookup'!M:O,2,0)="Deduction code",VLOOKUP(Q3,'accrural lookup'!M:O,3,0),"")

 

[Eric W]

Like this?

Book4
	M	N	O	P	Q																AG	AH
1	List	Code	Values
2	a	x	1
3	b	Deduction code	2		d																4
4	c	y	3		e
5	d	Workday Deduction Code	4		b																	2
6	e	z	5
7
Sheet7

Cell Formulas
Range	Formula
AG3:AG5	AG3	=IFERROR(IF(VLOOKUP(Q3,$M$2:$O$10,2,0)="Workday Deduction Code",VLOOKUP(Q3,$M$2:$O$10,3,0),""),"")
AH3:AH5	AH3	=IFERROR(IF(VLOOKUP(Q3,$M$2:$O$10,2,0)="Deduction Code",VLOOKUP(Q3,$M$2:$O$10,3,0),""),"")

 

[biglb79]

Hi,

For AG3 you could try:

=IF(VLOOKUP(Q3,'accrural lookup'!M:O,2,0)="Workday Deduction code",VLOOKUP(Q3,'accrural lookup'!M:O,3,0),"")

And for AH3 you could try:

=IF(VLOOKUP(Q3,'accrural lookup'!M:O,2,0)="Deduction code",VLOOKUP(Q3,'accrural lookup'!M:O,3,0),"")

perfect! thank you so much!