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!”
Here are some problems that our users have asked and received explanations on
i am looking to create a conditional formula (possibly including a VLOOKUP) to move information between worksheets.
Specifically, in the "pipeline" worksheet, for any entries listed over .6, I want to have the associated "client name" and "possible opportunity" information moved over to the "revenue forecast" worksheet
Solved by I. E. in 17 mins
I need help with a vlookup count! Please advise
Solved by K. A. in 25 mins
I can't get the vlookup for customers to work it has to show up as an exact match but I can't get the formula to show anything but NA its in column dc where I tried a vlookup
Solved by K. L. in 23 mins
My vlookup formula only works on 1st line of table.
Solved by E. S. in 13 mins
I am working on double vlookup function, please help advise on the case!
Solved by D. H. in 13 mins
I have two Excel Files, one file of customer orders placed and one file with customer orders invoiced. The key linking criteria is the Order# which is present in each file and I need to determine which orders have been invoiced (have an invoice number because they are completed). However, there can be more (multiple) Invoices for the same Order#. Thus, using vlookup only grabs one or the first occurrence. How do I get 2 formula columns to return proper results. One simple column that returns a Yes or No for IF an Invoice# is present for an Order# and a column next to that that returns the Invoice# when invoicing has occurred (even when the Invoice# is different for the same Order#).
Solved by D. F. in 15 mins
i need help with a percent change formula. i can not see why my values are incorrect. im calculating a percent change w 2 columns, one from a pivot table and another that was a VLookup
Solved by I. J. in 19 mins
Fix vlookup formula based on multiple criteria. Got cut off from previous expert. So need to finish off where previous expert left
Solved by T. W. in 23 mins
Dear Excel Experts, In Sheet 2, vlookup formula has been applied to obtain emp codes from sheet 1. However, unable to copy same formula to obtain DOJ.
Please find sheet attached and help to resolve.
Solved by S. S. in 25 mins
The following formula only sums one line of a spreadsheet. It should match a specific value in one tab and add all lines with this value together. It does not.
=SUMIF('Operating Exp.'!D2:S150,VLOOKUP(SUMMARY!A5,'Operating Exp.'!D:S,16,FALSE),'Operating Exp.'!D2:S151)
Solved by D. Y. in 25 mins