Need to do a VLOOKUP function based on 2 cells instead of just 1
Posted on 2012-04-12
I have 2 worksheets im needing to combine info on
I usually just use a VLOOKUP function to bring over the info i want. BUT in this case i have 2 cells i need to check before it brings the info over.
This is the function i normally use.
Like i said, in this case i need the vlookup to check 2 cells now.
1st cell i am checking is my "ReturnID"
I have some that have duplicate "ReturnID"
So i need to then check "LineNumber" then return the value i need.