G
Guest
Hello,
Strange thing happening here. I need to put several VLOOKUPS into a single
sheet in a workbook. I am pulling the data from several different tabs (one
tab per VLOOKUP). The first 3 VLs work fine. After that -- the VLs don't seem
to be able to catch a whole range of text-populated cells (they all start
with "C2"). I've tried most everything I can think of (changing the format of
the cells from text to general to number and back again) and I've triple
checked my VLOOKUP formulas -- they are exactly the same format as the one
that work (and the ranges and values are all what they should be). Is there a
limit to # of lookups you can have in a workbook?
The _only_ thing I can think of is that I created the worksheets for the
ones that don't work _after_ I inserted the initial VLOOKUPS into the main
sheet. The other worksheets were created before I put any formulas in the
main sheet.
Additional advice?
Thanks in advance!
-Trey
Strange thing happening here. I need to put several VLOOKUPS into a single
sheet in a workbook. I am pulling the data from several different tabs (one
tab per VLOOKUP). The first 3 VLs work fine. After that -- the VLs don't seem
to be able to catch a whole range of text-populated cells (they all start
with "C2"). I've tried most everything I can think of (changing the format of
the cells from text to general to number and back again) and I've triple
checked my VLOOKUP formulas -- they are exactly the same format as the one
that work (and the ranges and values are all what they should be). Is there a
limit to # of lookups you can have in a workbook?
The _only_ thing I can think of is that I created the worksheets for the
ones that don't work _after_ I inserted the initial VLOOKUPS into the main
sheet. The other worksheets were created before I put any formulas in the
main sheet.
Additional advice?
Thanks in advance!
-Trey