which function will work?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I haven't done any of this for 15 years and in those days I was working with dare I say 123! So I really would appreciate some help to refresh my memory. I have a database of customers in a spreadsheet. I also have a database of work carried out to those customers engines in another spreadsheet. I want to be able to click on a customer name in one spreadsheet and open up the data relating to that customer's work history. I'm sure I've done something similar before, but can't remember how to get started. I seem to think the lookup function would do it, but cannot see how, from the onscreen help

If anyone could steer me in the right direction, I would be grateful.
 
Maybe you could use VLOOKUP

=VLOOKUP(A1,Table,3,0)

where A1 would hold the name, Table would be the database with the leftmost
column
holding the names, 3 would be the column index counted from the left most
column which
would be the result.



--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

bestmom said:
I haven't done any of this for 15 years and in those days I was working
Click to expand...
with dare I say 123! So I really would appreciate some help to refresh my
memory. I have a database of customers in a spreadsheet. I also have a
database of work carried out to those customers engines in another
spreadsheet. I want to be able to click on a customer name in one
spreadsheet and open up the data relating to that customer's work history.
I'm sure I've done something similar before, but can't remember how to get
started. I seem to think the lookup function would do it, but cannot see
how, from the onscreen help.
 
Back
Top