# Multiple Rows & Columns Vlookup

1. ## Multiple Rows & Columns Vlookup

Dear All,

Since last three months I've tried my best to get the result, but I couldn't get. I have Three column heading "DATE, EMPLOYEE-NO, SHIFT" with more than 10000 rows. I want the results as each Employee Nos with 30/31 day's (Monthly) individual shift wise report.
Sample data is enclosed.

2. ## Re: Multiple Rows & Columns Vlookup

For the amount of rows you have I think doing this with formulas would take a very long time to calculate - I would suggest looking at restructuring your data or something. Anyway, in your example a formula like:
=IF(SUM(IF(\$A\$1:\$A\$1777=TEXT(G\$1,"0"),1,0)*IF(\$B\$1:\$B\$1777=\$F3,1,0)*IF(\$C\$1:\$C\$1777)=\$G2,1,0))>0,G\$2,"")
in G3 as an array formula (confirm with ctrl+shift+enter) and copied down and across would return your wanted result. If you combine this formulas to get your row/column headings dynamically though it will take ages to calculate for 10000rowsx31 columns.

3. ## Re: Multiple Rows & Columns Vlookup

See the attachement

4. ## Re: Multiple Rows & Columns Vlookup

Hello Mr.nflsales... It's working and it SOLVE my problem. Thank You very much.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1