Is it possible to extend the number of rows a spreadsheet has? I have a table that needs 115000 rows. I copy and pasted 65505 rows and that seemed to be the end. Does anyone have a clue how to do that?
Some of the values are in Column A and some are in Column D. So is there a way to write a function that merges these? It would save me a lot of work if I could drag the formula through all of my numbers instead of having to go through each one.
If you're trying to concatenate the information you can use:
=VLOOKUP(W129,Color!D:F,3,FALSE)&" "&VLOOKUP(W12,Color!A:C,3,FALSE) - Will return both matches with a space in between
=VLOOKUP(W129,Color!D:F,3,FALSE)&VLOOKUP(W12,Color !A:C,3,FALSE) - No space
Note that there's no error handling in there, so if you have blank information in either table, you'll need to add some. You can use IF(ISNA or use a range qualifier. i.e. =IF(SearchRange="","",VLOOKUP1())