multiple criteria lookups on vertical and horizontal

[ichristan21]

Hi,

Could anyone help me solve this problem, I uploaded the file where I want to have multiple criteria lookups, horizontally and vertically.



Thanks in Advance!

 

[Khalid NGO]

Hi,

Try the following in lOOKUP Sheet K7:
=INDEX('Data Entry'!$A$4:$UB$7,MATCH($E7,'Data Entry'!$C$4:$C$7,0),COLUMN('Data Entry'!W4))

Regards,

EDIT...
i forgot to match with dates, please ignore the above.

 

[ichristan21]

Yah right anyway still thanks for that, Khalid. What I want to happen is that when I search for specific date in lookup sheet in cell K5, cell K up to Q will show the result that lookup with ID no., Date and Subject Code no.

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[ichristan21]

Hi ,

See if this is OK.

Narayan

Hi Narayan991 Thanks a lot you've got it right by the way, how to remove #N/A if the lookup is empty?

Thanks again. . .

 

[NARAYANK991]

Hi ,

If you have Excel 2007 or later versions , you can use the IFERROR function.

See the attached file.

Narayan

 

[ichristan21]

Hi ,

If you have Excel 2007 or later versions , you can use the IFERROR function.

See the attached file.

Narayan

Thanks Thanks! you've got it perfect. . . Thanks to you and everyone here in chandoo. . . .