Get instant live Excel expert help with VLOOKUP formula

“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

I have a final Wednesday, and I would like a demonstration of how to use Vlookup and IF function for beginners
Solved by D. J. in 25 mins
Im having an error with the formula " =iferror(vlookup(Construction!B3,Table7[[Product No.]:[Bulk Price Unit]],3,false),iferror(vlookup(Construction!B3,Table8[[Product No.]:[Bulk Price Unit]],3,false),iferror(vlookup(Construction!B3,Table10[[Product No.]:[Bulk Price Unit]],3,false),iferror(vlookup(Construction!B3,Table11[[Product No.]:[Bulk Price Unit]],3,false),iferror(vlookup(Construction!B3,Table12[[Product No.]:[Bulk Price Unit]],3,false),iferror(vlookup(Construction!B3,Table13[[Product No.]:[Bulk Price Unit]],3,false)) " !
Solved by S. L. in 30 mins
I worked with one of your experts earlier today and need to revisit the formula that was written for functionality. I am re-uploading my file... Effectively, I am using a nested vlookup, indirect (and index/match) formula to identify the most recent historical price, historical date of most recent invoice and historical quantity of most recent invoice for a list of up to 10K SKUs. I have been pressure testing the excel formula and am questioning why the indirect formula seems to work only "some" of the time. For instance, in the first example (row 26 of the price sheet tab), the formulas in cell D26 and E26 seem to work. Specifically, the most recent invoice for the SKU listed in cell B26 of the tab is contained in the tab named "invoice #3". The date associated with that tab also pulls in correctly. However for the SKU listed in cell B27 of the price sheet tab, the most recent historical price pulls through correctly (from invoice #1, dated 1/18/2018). However, the date does not pull in correctly...cell E27 returns a "#N/A" Please let me know how to fix this. I would also like to add the same type of formula for referencing the quantity of the most recent invoice (in column F). Thanks,
Solved by K. Q. in 23 mins
I'm getting a reference error when trying to create a Vlookup. here is my formula =VLOOKUP(G6,'FKT Master'!B2:C43,3,FALSE)
Solved by A. J. in 21 mins
To determine which clothing lines may sell well online, you decide to rank them on a scale from A to E. In cell H5, using a Vlookup function, determine the product line ranking of each product based on the Yearly Sales. Use the range name assigned to the lookup table. Copy the formula through H16. In cell H21, using a Vlookup function, determine the product line ranking of each product based on the Yearly Sales. Use the range name assigned to the lookup table. Copy the formula through H32.
Solved by Z. Y. in 26 mins
greetings i need help creating a vlookup formula that will use cross reference to show total commission. more info will be provided
Solved by Z. C. in 21 mins
I'm having trouble pulling data with a Vlookup formula. Only some values are pulling up from my chart.
Solved by G. E. in 19 mins
I need help with Indirect Vlookup function on adding additional reference worksheets after the formula was already created
Solved by E. H. in 18 mins
I'd like to adjust the formula "iferror(vlookup" to also subtract the previous amount that the conditional formatted cost was.
Solved by V. H. in 20 mins
Hello I wonder if you can help me. I am looking for advanced excel formula, can you please help me? My example is as follows:Formula to be in Cell D27 If engagement type in cell D17 is "this" or "that (there are 5 categories) show me the rate corresponding to job as per cell D26, Rates are available in other tab in separate columns for both types of engaments. So I wonder what would be the clever formula that selects rates values and vlookup to select appropriate job category in cell D26. Thank you
Solved by A. H. in 18 mins