Q&A for How to Use Vlookup With an Excel Spreadsheet

Return to Full Article

Coming soon

Add New Question

Question

Can I put Vlookup formula for 5 raw data in one command?

NurtureTech Academy

Community Answer

Yes, you can get 5 raw data on a single command with array function. For example; Vlookup (A1,A1:F5,{2,3,4,5,6},0) after than do not hit enter you have to press ctrl+shift+enter.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 15 Helpful 32
Question

How do I find repetitive information?

Community Answer

Use Conditional Formatting under the Home Tab in Excel. You can highlight duplicates. It is also possible to downright remove duplicates using another function under the Data Tab

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 10 Helpful 26
Question

What is excel coding?

Community Answer

Excel uses VBA. To access this, you need to edit your ribbon banner and select the "Developer" option to be added to your ribbon. This is typically used for things like Macros.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 6 Helpful 10
Question

How can I add data vertically on one sheet but have it update horizontally on another?

Community Answer

Copy the vertical (or horizontal data) and click "Paste Special". When the dialogue box appears, click "Transpose" and then Enter.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 1 Helpful 6
Question

How can I use vlookup with multiple lookup value? For example, you have 3 rows (A)date (B)plate number (C)drivers name. In a situation that if the date is__ and the plate no. is__ then the driver is__

Thomas Bennett

Community Answer

You would use an INDEX MATCH with an array ideally for this. Below is an example of a three criteria Index match with each criteria in columns C,D and E and the formula returning column G. =INDEX(C:G,MATCH(1,(C:C="East")*(D:D="Jones")*(E:E=10),),4). In column C you are matching "East" in D "Jones" and in E "10". Each of these arguments is separated by a "*". How this works in basic terms is Excel creates three invisible rows, 1s are assigned if each criteria is met. It multiplies all the invisible rows together then match returns the row number (that's why the first match argument is 1 too.)

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 0
Question

What does the colon mean in the VLOOKUP formula?

Thomas Bennett

Community Answer

It defines a range of cells. A1:A3 reads as A1 to A3. Meaning cells A1 A2 and A3 are involved in the range. The same applies to ranges of columns. A1:D1 would mean cells A1, B1, C1 and D1 are all in the range. You can define a 2d range with something like A1:D10 too. Cells A1 A2 A3 A4 up to A10, B1 B2 B3 B4 up to B10, C1 to C10 and d1 to D10 would all be included in the range. A:A would mean all rows in column A are in the range. 5:5 means all columns in row 5 are in the range.

Thanks! We're glad this was helpful.
Thank you for your feedback.
If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
Yes No

Not Helpful 0 Helpful 1