internetz wrote:yeah, ideally you want the sheet that holds richards lookup to be 500-1000 rows longer at the end, and use a named range that includes those extra rows. That way when richard adds things, there's room in the table for your sheet to add them too
I've requested edit access, if you just want me to fix it so that it wont break again when Richard adds new items.
I'm sorry I was obsessed with something else so I couldn't focus on this. I'm too lazy to fix this small sheet. Thx for Richard and abqu for keeping spreadsheet up-to-date all the time.
hmm, anyway, I accepted your edit access. Thx!