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

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