• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VLOOKUP, IF/MATCH or MATCH/INDEX

Jaimee001

Jaimee001

Member
Hello all....I have a workbook with 2 tabs. The first tab includes about 100K rows of data. Tab2 includes about 2000 rows of data with some fields being blank. Each tab has an account number. ON Tab 1 I want to do a formula that pulls the data from tab2 where there is a match on the account number (including blanks) and if there isn't a match, I want that to be blank as well. I tried to do VLOOKUP and it didn't work.


Here is my mock up:[pre]http://speedy.sh/zQ9Wp/Example-for-VLookup-based-on-2-sheets-multi-rows.xlsx[/pre]


I also tried to do an if/match but I'm not sure of that format....


Thanks in advance!!!
 
Hi Jaimee001,


Have you used the last option of VLOOKUP()function?? I am using this one and it is working:


Code: 
=VLOOKUP(A2,'Menu Lookup'!$A$2:$B$13,2,FALSE)


False for exact match...for ur given sheet it is working.


Faseeh
 
Thank you Faseeh, you are absolutely right...I don't know what I was doing wrong but the VLOOKUP formula works just fine....Thanks again!
 
You must log in or register to reply here.
Back
Top