VLOOKUP and names with Commas

  • Thread starter Rpt_Me4NotBeingSmart
  • Start date
R

Rpt_Me4NotBeingSmart

I am using the below formula in D195 to look up an employee's hours.
B195 is Doe, Jane
from the search array, Doe, Jane is in B139 and Doe, Jack is in B138. The
values keep pulling from Jack. Is there a way force it to pull from Jane?

=VLOOKUP(B195,$B$9:$G$190,2)
 
S

Sheeloo

Use False as the fourth parameter...
=VLOOKUP(B195,$B$9:$G$190,2,FALSE)

This is from HELP -
When the fourth parameter is either TRUE or is omitted, an exact or
approximate match is returned. If an exact match is not found, the next
largest value that is less than lookup_value is returned. If range_lookup is
either TRUE or is omitted, the values in the first column of table_array must
be placed in ascending sort order; otherwise, VLOOKUP might not return the
correct value.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto populate fields 1
How to Remove dup names and if same rate. 3
Please help****I am trying to create a formula and it doesn't work!!!! 2
Commas in a string of text 0
Is there a limit? 4
Commas in a string of text in VBA 2
Auto copy data from 1 sheet into another 1
Drop downs and look up 4

Top