Hi,
Just registered to this forum and looking for some guidance. I have attached the spreadsheet I am working on.
I am trying to use the "vlookup" function to look up account names using an existing account number. The first sheet has the table with account numbers and names. The second sheet is where I am trying to look up customer names in column C.
I cannot get the function to work as you can see in cell C2. Any idea on what I am doing wrong?
Thanks!
Try this
=VLOOKUP(B2,'Company Names'!$C$2:$D$512,2,FALSE)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you so much!! Why does locking the table cells fix it?
Repped!
Range needs to locked so it wouldn't change when you pull formula down. VLOOKUP function looks through entire range to find matching value.Originally Posted by ILspeed3
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks