Originally posted by bkballer I need help using vlookup with 2 lookup values. I know i need to use a if statement but i don't know how.
Sounds to me Vlookup might not be what you want maybe index and match?
Can you post up a Excel Workbook with a small sample and let us know what you require, so we can try to get a workable solution for you. I just have a feeling Vlookup might not be best in this case, could be wrong?