# Get instant live Excel expert help figuring out how to do a VLOOKUP

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

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## Here are some problems that our users have asked and received explanations on

I have win/loss columns for player stats and I need help using rank and percentile data analysis tool......I want to be able to pull up the player name using vlookup next to the rank and percentile table but I don't know how to do that; please and thank you!
Solved by K. S. in 11 mins
I have a column with Zip codes in it and I want to find the associated county with that zip code. I have a table on a separate sheet that has hundreds on zip does and the associated county. I receive reports that will only have the zip code and not the county. is there a way to have that zip code automatically associate with the county without having to go look it up myself on the separate sheet. I tried using VLOOKUP but it still only works by typing in each zip code into the formula each time. maybe data validation? Not sure how to do it
Solved by B. U. in 26 mins
I am having a problem with figuring out how to use lookup in excel
Solved by K. H. in 25 mins
how to do vlookup for with reference to the pages
Solved by O. D. in 16 mins
I know vlookup. I had a training session where I learnt about excel column number calculator and that column number can be added dynamically or something like that so when new column inserted in table row, it doesn't give error. Now I have forgotten how to do that and can't find anything on google.
Solved by C. H. in 11 mins
Column A1: a, col.B1:1, Col A2: a, Col B2: 1- on other excell file doing vlookup col A to show col B- when there are same values as example there are 2x a with diff values (1 and 2) vlookup pick up the 1st one (1) so on both shows 1 instead 1 and 2, how to do it?
Solved by E. H. in 25 mins
I need to learn how to do lookup in excel between two different sheets
Solved by V. C. in 13 mins
I'm struggling with a vlookup query (I've never done one before). I have run two reports from separate systems - one showing sales figures, the other showing metadata assigned to each product. I want to combine these two sheets so that I can identify gaps in our metadata and sort them in order of highest sales. Only one column from each sheet contains identical data that would match the products together, but I'm not sure how to do this. Can you help?
Solved by X. H. in 11 mins
I UPLOADED A FILE WHERE THERE ARE 2 SHEETS:SHEET 1 I EDIT ANYTHING I WANT AND IN SHEET 2 I ACCESS THEM. IN SHEET 2 THERE IS "ENTER ID HERE".WHAT I WANT TO DO IS TO ENTER THE ID OF THE STUDENT AND ALL THE OTHERS(NAME,EXAM 1,2, FINAL EXAM, ATTENDANCE,PROJECT,GRADE,LETTER,CONCLUSION) WILL APPEAR AS SOON I ENTER THE ID.HOW TO DO IT USING BOTH INDEX-MATCH FORMULA AND VLOOKUP: THANK YOU
Solved by I. U. in 19 mins
I have a file with three sheets. One needs to be copied and pasted properly without a data mixup and the the other needs a vlookup done properly which I have no idea how to do.
Solved by T. U. in 21 mins