“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

how do i correctly use vlookup and pivot tables for my aat level 3 exam

Solved by B. Y. in 30 mins

attempting to use VLOOKUP to populate different football position wristbands from a master sheet

Solved by B. B. in 18 mins

im trying to create a template for a furniture store so we can total individual employee sales and consignment sales. im having troubles with vlookup to get the desired results

Solved by E. Q. in 13 mins

I'm trying to recode stings into numbers; e.g. Sometimes=0, most of the time = 1, all the time =2.
I used the VLOOKUP function, but it doesn't convert the "most of the time" and "all the time" variables.
Can you help me?

Solved by V. D. in 16 mins

Hi there,
I am trying to do a vlookup using addresses, to get the job ID numbers attached to job addresses.I have one lot of data with addresses and missing job numbers and another with addresses and job numbers. How do I replace the missing job numbers with the correct addresses.

Solved by G. L. in 27 mins

I am using vlookup function, in 2 worksheets, and I cannot copy the formula for more than a few rows until I get #n/a.
I am using excel 2007 on a MAC. can you help?

Solved by I. J. in 12 mins

I need to compare two spreadsheets and need vlookup explanation

Solved by A. E. in 17 mins

I have a list that from column E thru H values E=a date (e.g. 6-June-17), Column H has a dollar (e.g. $421.0). On another page I am trying to find make a statement page summary that will pick out the month and put the dollar value in that box without giving me an #NA (such as when you use Vlookup).

Solved by Z. C. in 30 mins

Vlookup function to determine the commission rate. Lookup the SalesID for each order (from column F). Return the “Commission Rate” that for that SalesID to column I.

Solved by X. E. in 25 mins

Hi, I am looking for quick coaching on what I believe is the SUMPRODUCT formula, for doing a lookup that involves greater than or less than values in a target cell, to then return a specific value in a different cell.
For example. I am measuring the value in B2, and depending if it is less than, equal to, or greater than a value in cell in c2, return the corresponding value from a table L4:N9. Kind of like a vlookup but different.
Can you help with this? Should be quick and I am looking for assistance asap. Thank you!

Solved by M. J. in 11 mins