vlookup help

OK....so I am struggling with this vlookup. Perhaps I can not do what I want to do. Any comments would be helpful.

I have a sheet that has customer number and customer name. Customer number is auto generated and is sequential. CU1000033 is my number. Name XYZ Sports Academy.

I have a pitcher that uses XYZ Sports Academy to practice in and I want them to link their "home" practice facility into the pitchers records.....so I produce a drop down for the pitcher to select the correct name.

I also have the customer number in the pitchers record as well as the coach number that he/she practices with. I have a drop down in the pitcher record to record the coach name also.

I am trying to use the Coach master file and the Customer Master file to automatically fill in the Customer Number and the CoachID using vlookup from the other sheets. I have an exact match in customer name and coach name in the pitcher file.

I thought I could select the row and column and

use this formula =vlookup(customername,CustomerMaster,1,true) hoping it would match the Customer Name from both files and return the customer number to me ......

I am very new to this so any suggestions on what I am doing wrong...or can I do what I am trying to do at all......Tom

Find more posts tagged with

Formulas

Cell linking

Comments

Sterling

Looks right to me, although you'll need to have the cell number and the sheet link will need to be set up within the formula. In the end the formula in cell 1 should look something like this:

=VLOOKUP(customername1, {CustomerMaster Range 1}, 2, false)

tom55166

Thank you will give that a try...was the syntax correct?

Sterling

Hi Tom,

I've had similar issues when I try to look for an exact match, setting that value to false usually helps and I haven't had any issues with that to date. Another thing is that I've found, is that the value you're matching with may need to be in the far left column (not 100% sure on this) and the value you want to return can be anywhere else in the row.

Hope this helps.

TRowan63891

I have had it happen many times the issue is the formatting for the two columns you are comparing. Ex: One is not text and the other general.

So check the formatting to see if that is the issue

Quick Links

Trending discussions

VLOOKUP vs CONTAINS
This discussion was created from comments split from: How to detect multiple dropdown values in a contains function?.
Using SUMIFS with Cross Sheet References and CONTAINS
There seems to be lots of information on how to use SUMIFS with a CONTAINS criteria, referring to another sheet. Here is my formula on Sheet 1: =SUMIFS({Total Cost - Final Event Space Cost}, {Requested Event Date}, {Requested Event Date} > TODAY(), {Requested Event Date}, {Requested Event Date} >= TODAY(-365)) Total Cost -…
Networkdays when doing sums
I have a working formula (below) that works well, but includes weekends in the return. I am finding a date in a range, and then adding Duration per products X #products. How do I get it to work with weekdays only? =MAX(COLLECT(Assigned:Assigned, Priority:Priority, "HP 1")) + (MIN(COLLECT([product counts]:[product counts],…