Vlookup - Help to compare accross three worksheets

K

Kukulkan

I have been tasked with comparing our list of 85,000 active parts
against a list of 250,000 part numbers that may be deleted from our
master database. Since all the active parts will not fit on one
worksheet, I need to create a VLOOKUP formula that will allow me to
compare the parts they have given me against a column of part numbers
that spans two worksheets. What would be the best way to do that?
 
P

pape

You could use IF with ISNA to look for the part number - just nest the
IF statements as many times as you need.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro: VBA code to move/forward email based on subjects and attachments 0
vlookup text in vba 3
How to compare and combine information from 2 different excelworksheets (VLOOKUP ? Pivot Table ?) 1
Drop down box w/contents of different worksheet? is this possible 1
Creating Labels Over 3-Up Image 2
VLookup accross multiple worksheets 8
Intricate Cell Formatting Question 1
Trying to reference two sets of data with one number 1

Top