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

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

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.

tom55166

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

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)

Sign in to join the conversation!

Quick Links

Trending discussions

Is there a way to create a 3-digit padding for numbers
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?