I am trying to do a formula to look up the zip code on the "Tanika All" sheet against the list of zip codes in each the "Tanika Medical" & "Tanika Dental" worksheet. At first I wanted it to return the text "Medical" if it was found in the medical sheet or "dental" if it was found on the dental sheet. Or "Both" if it was found on both sheets.
There is mixed formatting and it's a huge list of data. So I have tried vlookups & index match, if functions, sumproduct functions trying to get even just two lists that lookup if the zip code matches to the other two spreadsheets. I used the formula below and made it an array formula and was able to get it for the most part to match everything but the ones that start with 0's.
Someone please help me.
=IFERROR(VLOOKUP(""&F2&"",TEXT('[Tanika Medical.xlsx]Sheet1'!$A:$A,"0"),1,FALSE),"")
*****I had to remove half of the lines on the medical file to get it to upload to this post. There is usually almost 47,000 lines*****
Bookmarks