# 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!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

hello I am not sure what formula to use. I have a table in a spreadhseet which shows client names, codes and their department numbers. The second spreadsheet has all the invoices received for each client in a month, rather than looking up and typing the department code for each client i want to enter a formula which will look it up and enter it ofr me. think it is a lookup formula but not sure, can you help?
Solved by Z. B. in 30 mins
need help finding # amiibos sold in particular region. i have a scalar needed to do rank lookup for the scalar ,specifying using vlookup *population in particular region *22% have a nintendo 15% of those have amiibos (10-rank)^2/100, square the value of (10-the rank value)/100
Solved by C. W. in 15 mins
I need help with lookup formula. If value in colum A in sheet1 is present in colum A in sheet2, I need the value from colum E in sheet2 to show up in Colum H in sheet1.
Solved by A. Q. in 28 mins