Get instant live Excel expert VLOOKUP help
“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 have a VLOOKUP formula example from a competent source but the lookup is not working.
Can you help?
Solved by Z. C. in 12 mins
Need help with Vlookup, need to have data automatically populate from one tab to another tab based on once data is inputed into cell
Solved by E. E. in 21 mins
Hi, I have two workbooks. I want the first workbook to reflect in various columns a code which is on the second workbook. With help of a username on both workbooks, it should be possible to vlookup correct?
Solved by I. J. in 28 mins
Hi, I'm looking to create a from by typing in the reg and it pulling through the data from the data tab. I've tried this as a VLookup but it only pulls through the first line and there may be more than one line under each reg for repair history. I tried doing this as a pivot table, but I don't like the layout of it and wanted to be able to type in a reg and it search for the data rather than filtering. I've tried a combination of both by creating a macro to copy the data from cell A1, refresh the data in the pivot table, filtering by pasting the results from A1 then copying the relevant data I require onto the form tab. It works, but when I change the reg it remembers the actual reg text from the macro rather than the act of copying and pasting the data in A1 from the form. Can you help me please?
Solved by K. J. in 14 mins
Hi, need help with typing a code for macro or for a button, either way, I have two tables. In that macro I need to use something like a vlookup and match all items from table 1 with items from table 2, and to do so in all columns in table 2 containing certain text. Then populate the results from the vlookup.
Solved by D. S. in 22 mins
vlookup help. trying to use the table on the right to input the types in their appropriate columns.
Solved by C. H. in 30 mins
Vlookup or match help, having issues creating the formula
Solved by X. Y. in 11 mins
I need help with vlookup problem. how are we supposed to do it?
Solved by X. L. in 18 mins
I need help in understanding how a vlookup function works
Solved by Z. W. in 23 mins
help using Vlookup, I have a table where I have product codes, volumes, times we produce & empty tanks.
my assignements is to create a tool that works out which products are being produced at what times (hourly) and what tanks they are to be processed into.
Solved by I. S. in 11 mins