What Function Should I Use??

[TJM12]

Hi... Im struggling a little bit to find the correct method or function to search for something i need in particular. I have a series of spreadsheets set up nicely within one database. I search for a persons name (easy enough to do) but then I want to find out how old they are. This information is on a different spread sheet and instead of having to input the data for each activity they come to and on every sheet , I would like to know how to find out their date of birth, for example on the original sheet??? I hope this makes sense, if you need clarification, just ask and I can send an example perhaps??

 

[Joe4]

Welcome to the Board!

Assuming that your have their date of birth on the same row as their name on the original sheet, you may be able to use VLOOKUP to pull their date of birth back.
See: https://www.techonthenet.com/excel/formulas/vlookup.php

 

[AkaTrouble]

welcome to the forum

couple of question (just terminology as your new to forum)

database is not an Excel term we say table or range

you say series of spreadsheets do you mean series of worksheets in one workbook ?

if my assumptions are correct you can use either VLookup or index & match functions to retrieve the data

we would need an idea of layout sheet names etc but a simplified example lets say you have a sheet called contacts and want to return results to another sheet

Contacts sheet

name	address	telephone
name1	address1	telephone1
name2	changed	telephone2
name3	address3	telephone3
name4	address4	telephone4
name5	address5	telephone5
name6	address6	telephone6
name7	address7	telephone7
name8	address8	telephone8
name9	address9	telephone9

<colgroup><col><col><col></colgroup><tbody>
</tbody>

on another sheet

search for	return result	formula
name1	address1	<< =VLOOKUP(A19,contacts!A2:C10,2)

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[TJM12]

Welcome to the Board!

Assuming that your have their date of birth on the same row as their name on the original sheet, you may be able to use VLOOKUP to pull their date of birth back.
See: https://www.techonthenet.com/excel/formulas/vlookup.php

Thank you very much for response. You're the star!, everything is sorted and running smooth.

Many thanks again
Thomas.

 

[Joe4]

You are welcome!
Glad I could help.

 

[TJM12]

welcome to the forum

couple of question (just terminology as your new to forum)

database is not an Excel term we say table or range

you say series of spreadsheets do you mean series of worksheets in one workbook ?

if my assumptions are correct you can use either VLookup or index & match functions to retrieve the data

we would need an idea of layout sheet names etc but a simplified example lets say you have a sheet called contacts and want to return results to another sheet

Contacts sheet

name	address	telephone
name1	address1	telephone1
name2	changed	telephone2
name3	address3	telephone3
name4	address4	telephone4
name5	address5	telephone5
name6	address6	telephone6
name7	address7	telephone7
name8	address8	telephone8
name9	address9	telephone9

<tbody>
</tbody>

on another sheet

search for	return result	formula
name1	address1	<< =VLOOKUP(A19,contacts!A2:C10,2)

<tbody>
</tbody>

Thank you very much for response. You're the star!, everything is sorted and running smooth.

Many thanks again
Thomas.