Ardus Petus: Ran in to a problem with the formula Please Help

  • Thread starter Thread starter mrdata
  • Start date Start date
M

mrdata

=VLOOKUP(TEXT(F5,0),Jobs!A:B,2,0)

The formula you gave me above worked great until I added a few more
rows of data to the Jobs worksheet.

Any entry that was added past the original entrys will not lookup.
Did I loose the formula referance?
should I rename the worksheet?

What do I need to do to get this to work again?
It works down to row 50 but after that nothing is returned I check to
make sure all cells were formated the same and I also tried sorting the
list ascending didn't help.
I will need it to search at least 100 rows


Thanks
Charles
 
You must log in or register to reply here.

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

VBA coding a nested Vlookup, and a sumif formula 5
Formula help please 1
Formula help please 4
Displaying the name of a worksheet in a cell ? 1
PLEASE HELP - COPY VLOOKUP 6
Referencing Multiple Worksheets using VLOOKUP and INDIRECT 3
Retrieving data from a cell in the last row containing data in the worksheet 1
Help with ISNUMBER formula 2

Back
Top