Hi, on attached workbook, on ‘Pivot’ sheet, I want to check to see if any cell in the A column matches any part of any cell in J:J. If a match is found I want to take the corresponding value found in L:L and display it in F:F

I hope that’s clear, and is there any chance someone could clarify the reason why the formula that is currently in F:F is incorrect?

Since you are using Pivot Table in Excel 2003 and I would like to offer a tip for you...

In your attached File just place the cursor in B3 Cell and Click on the Text Data and hold and drag it to Total Text That is C3 and leave it then you will get the data which looks like the below attachment file.

Refer the attached file for vlookup formula and change in Pivot layout...

Perhaps.

=IFERROR(INDEX(\$L\$4:\$L\$47,MATCH(LEFT(A4,13),\$J\$4:\$J\$47,0)),"")

Edit: For Excel<2007

=IF(ISERROR(INDEX(\$L\$4:\$L\$47,MATCH(LEFT(A4,13),\$J\$4:\$J\$47,0))),"",INDEX(\$L\$4:\$L\$47,MATCH(LEFT(A4,13),\$J\$4:\$J\$47,0)))

Press F2 on the cells with formula shows #N/A
You will see that some points to an empty cell and for some there is not match in your lookup table.
Go to Report Layot of your PT and click Repeat all item.
This will solve some of your problems( not hte one when you have not match)

BTW your firmula should look like this
=VLOOKUP(A4,J:L,3,0)

Your formula is fine, just needed to tune it

Thanks for all the help guys! Shyamhappy, when I use your formula, I end up displaying results from J:J in F:F, is there a way so that the contents of L:L are displayed in F:F

Thanks Sixth Sense, the tip was hella useful!

Fotis1991, I know it's probably because i'm a noob, but when I put your formula in it's not working!

..Fotis1991, I know it's probably because i'm a noob, but when I put your formula in it's not working!
No worries. See the example pls.

Perfect! Job done, cheers guys! This is why this forum is one of the best

You are welcome(from ALL of us) and thanks for the feed back.

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