vlookup (i think!) to pull data using multiple criteria and two worksheets I hav

Question

vlookup (i think!) to pull data using multiple criteria and two worksheets

I have a workbook with two worksheets. These items are in columns A, B, aand C

Name                               Department                        Cllient

Worksheet 2 has exactly the same in columns 1, 2, and 3 but also has a $ in column 4.

On worksheet 1 i want to enter the $ from worksheet 2 (column 4) into column H. I want to make sure that the name, department and client match. (One client may be listed more than once if work was performed in more than one department.

Can someone help me? I have tried nesting vlookups but am not really sure that is the answer.

the worksheets have a couplee thousand roows.

Thanks yet again!!!

Explanation / Answer

In H2 of final tab enter following array formula and drag down -

(Note - Array Formula is not entered by pressing ENTER after entering your formula but by pressing CTRL+SHIFT+ENTER. This will put { } brackets around the formula which you can see in Formula Bar. If you edit again, you will have to do CTRL+SHIFT+ENTER again. Don't put { } manually.)

=IFERROR(INDEX(Sheet4!$D$1:$D$1000,MATCH(A2&B2&C2,Sheet4!$A$1:$A$1000&Sheet4!$B$1:$B$1000&Sheet4!$C$1:$C$1000,0)),"")

Note - Your row 1 in both ssheets aare having Jones, Jack and Jonees, Jack which will not match because of spaces between Jones and Jack. Hence, you need to have correct data for match to haappen....

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.