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'm using Vlookup successfully and want to catch #N/A errors. I've tried both IFERROR and IFNA to replace the #N/A with "". The cell just shows the formula and does not execute as expected. Help?
Solved by S. D. in 18 mins
problem with vlookup - the formula is working on fine. When I copy it to another cell its not working. But if I type it manually then everything is fine.
Solved by S. H. in 17 mins
Trying to do a vlookup across two separate columns but my formula doesn't seem to be working.
Solved by B. B. in 28 mins
Which of the following statements are true? (Select all that apply.)
The VLOOKUP and HLOOKUP formulas can be used interchangeably.
The VLOOKUP formula returns the value of a cell based on a specified column.
The VLOOKUP formula returns the value of a cell based on a specified row.
The HLOOKUP formula returns the value of a cell based on a specified row.
Solved by O. J. in 18 mins
Need someone exlain vlookup in excel for dummies. Vlookup formula not working and cannot find out why!
Solved by E. H. in 11 mins
Greetings,
I need a VLOOKUP Formula that updates data based on the corresponding values. I will provide more information
Solved by G. E. in 20 mins
Greetings,
I need an if VLOOKUP formula based on the corresponding instructions
If you do not know how to incorporate it into vlookup please let someone else answer thank you!
(1) If the updated data from a provider matches LACHD’s estimate, the amount stays as the estimated value; (2) if there is no report from a provider, the amount stays as the estimated value; (3) if the estimated value deviates from the reported actual value, the reported value is used to update (replace) the estimated value.
Solved by B. L. in 18 mins
I need to import site location info from one program into another.
I exported the data to client_sites.005.xlsx. The sheet sites.004 has ALL the address data.
The sheet ClientSites is the import template. As you can see there is only space for one location at a time in the template. Most my customers have only one location but some have more.
I tried to use vlookup but was having issues. I need a formula to pull the "shipto" info into the appropriate columns in the "template".
Template Fields => export fields
"Client Code" => "Customer ID"
"Client Name" => "Customer Name"
"Site Name" => Customer Name" & "Ship to Address City"
etc...
Solved by Z. C. in 25 mins
I need vlookup formula help. I have Column with an id , i have a column that contains that id, and a column that contains a date for that id. I'm having trouble just getting the formula to work.
Solved by X. L. in 27 mins
Need help putting together a simply vlookup formula.....
Solved by C. W. in 23 mins