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...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
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)))
Last edited by Fotis1991; 08-27-2013 at 04:00 AM. Reason: Edit
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
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)
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Your formula is fine, just needed to tune it
=IF(ISNA(VLOOKUP(A46,J:J,1,L:L)),"Record Not Found",VLOOKUP(A46,J:J,1,L:L))
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
RobertMika, about to try yours
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!
No worries. See the example pls...Fotis1991, I know it's probably because i'm a noob, but when I put your formula in it's not working!
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
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks