You are reading a single comment by @rhb and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@rhb
Edit ignore - data validation drop down cell + xlookup has worked. Ta
I have a 'form' in excel from finance. I need to complete multiple times quick filled with data from an excel table. They won't accept return in word, must be excel.
My solution is to create a check cell to allow me to control which row is being looked up.
E.g. I type 1 = looks up A1, i change it to 7 it looks up A7. I can file >;save as to create each copy for submission.
I can't get this bit working even though it seems simple though. Can anyone help. I think it might need =Indirect() but I'm not getting anywhere.