IF(ISNA(VLOOKUP I want to add AND

[jojoluv377]

I need to LookUp G47 in the 'CONTRACT WORKFORCE'!$E$4:$R$99 and once it finds it a D47 has to match Col 5 on 'CONTRACT WORKFORCE'!$E$4:$R$99.

=IF(ISNA(VLOOKUP(G47,'CONTRACT WORKFORCE'!$E$4:$R$99,11,FALSE)),"",VLOOKUP(G47,'CONTRACT WORKFORCE'!$E$4:$R$99,11,FALSE))

I think I should add AND but I am not sure where. Any ideas? I've been working on this for a while.

Jackie

 

[sr12345]

I need to LookUp G47 in the 'CONTRACT WORKFORCE'!$E$4:$R$99 and once it finds it a D47 has to match Col 5 on 'CONTRACT WORKFORCE'!$E$4:$R$99...

Jackie,
Can you try restating the question? So, after you do the first lookup, what are you trying to do? Use that value to seed another lookup?

 

[jojoluv377]

Once lookup finds the record (cell), a second cell needs to be matched to return the correct result from column 11.

Thank You
Jackie

 

[barry houdini]

Try

=INDEX('CONTRACT WORKFORCE'!$O$4:$O$99,MATCH(1,INDEX((G47='CONTRACT WORKFORCE'!$E$4:$E$99)*(D47='CONTRACT WORKFORCE'!$I$4:$I$99),0),0))

 

[bosco_yip]

Or this

=INDEX('CONTRACT WORKFORCE'!$O$4:$O$99,MATCH(2,INDEX((G47='CONTRACT WORKFORCE'!$E$4:$E$99)+(D47='CONTRACT WORKFORCE'!$I$4:$I$99),,1),))

=INDEX(OFFSET('CONTRACT WORKFORCE'!$O$3,MATCH(1,INDEX((G47='CONTRACT WORKFORCE'!$E$4:$E$99)*(D47='CONTRACT WORKFORCE'!$I$4:$I$99),),),),)

=INDEX('CONTRACT WORKFORCE'!$E$4:$O$99,MATCH(1,INDEX((G47='CONTRACT WORKFORCE'!$E$4:$E$99)*(D47='CONTRACT WORKFORCE'!$I$4:$I$99),,1),),) 'CONTRACT WORKFORCE'!$O$4:$O$99

Regards

 

[jojoluv377]

Try

=INDEX('CONTRACT WORKFORCE'!$O$4:$O$99,MATCH(1,INDEX((G47='CONTRACT WORKFORCE'!$E$4:$E$99)*(D47='CONTRACT WORKFORCE'!$I$4:$I$99),0),0))

This worked. Thank you. I am still in the learning process with nesting formulas. But I appreciate the quick response.