Get instant live Excel expert help with LOOKUP Function
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Prepare some form of a lookup that returns the names that appear on both lists. For each name prepare a lookup that returns the rank of the name on both the male and female lists.Hint: There are only 331 names that are common between males and females. Use a combination of the functions
SMALL and LOOKUP and VLOOKUP.
Solved by I. E. in 15 mins
this is av lookup issue. I have two files. I pulled all the email addresses off the main list, then cleaned it via kickbox. I found there will many duplicates in the email only list that I also removed.
Now I want to compare it to the original list and have only the "good" emails, but want all the other info associated with it.
I also have the other list, but it won't let me upload a second file.
Solved by S. B. in 15 mins
Trying to set up v lookup on 3 columns. Trying to minmize all the if statements in a cell.
Solved by T. L. in 29 mins
I need help with a lookup problem. I am confused with entering the vecotrs
Solved by B. H. in 11 mins
Trying to use Index and Match, to lookup two cloumns and return a date, but keep getting a "#Value" error
Solved by M. H. in 15 mins
Needing to do a vlookup but my LOOKUP Value doenst match 100% to my source data.
Solved by I. J. in 22 mins
3. In cell E14, write a formula using a LOOKUP function to calculate the unit price for this order based on the quantity ordered. Write the formula so that it can be copied down the column, and then copy the formula into cells E15:E19.
Solved by I. H. in 23 mins
This is a vlookup using 2 spreadsheets. I need to use SOEID as lookup value toinsert "STLT name" from Tampa People Data tab as the return value.
Solved by E. L. in 28 mins
I need to do a lookup to on the "walmart store #" to return Region, Market # and Market from sheet two to sheet one
Solved by B. H. in 12 mins