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
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