Lookup Data

[smr384]

I have two excel spreadsheets, one is a database of information sorted by dates and categories and the other is a presentation sheet. What I am looking to do is to be able to type the date of the information I am looking for into one cell on the presentation sheet and then have the information that is associated with that date on the database sheet to fill the cells on the presentation sheet. The format of the two sheets is the same. Ideally I would like to use a formula if possible. If anyone can help it would be greatly appreciated.

 

[VoG]

Try VLOOKUP http://www.contextures.com/xlFunctions02.html

 

[Desu Nota from Columbus]

=Vlookup($A$2, '[DATABASE.xls]Sheet1'!$A$1:$Z$100, 2)


drag this formula across the row.


Change the blue 2 to 3, then 4, then 5...etc. for each new column.

And match the formula to your data.

 

[Desu Nota from Columbus]

http://www.youtube.com/watch?v=lfm7ns8ZC6E

video tutorial.

 

[smr384]

Thanks for the response. Can I use VLOOKUP if I am searching using 4 sets of criteria or do I have to use the index formula? My data is sorted by date, index, and two different indicators (call them indicator #1 and indicator #2).

 

[Desu Nota from Columbus]

Depending on the data you want to return, you could use either INDEX + Match, or possible SUMPRODUCT.

 

[snoopyhr]

<>

 

[Jared_8878]

=Vlookup($A$2, '[DATABASE.xls]Sheet1'!$A$1:$Z$100, 2)


drag this formula across the row.


Change the blue 2 to 3, then 4, then 5...etc. for each new column.

And match the formula to your data.

Just as a note for the 2, if you are copying it across just replace the 2 with column()-5 , the -5 being the initial adjustment to get the right number, then when you drag the formula across you don't have to manually change as you do with the constant 2.

 

[VoG]

Just as a note for the 2, if you are copying it across just replace the 2 with column()-5 , the -5 being the initial adjustment to get the right number, then when you drag the formula across you don't have to manually change as you do with the constant 2.

Which will go **** up if columns are inserted or deleted

 

[Jared_8878]

Which will go **** up if columns are inserted or deleted

thanks for that, I assumed to much for him.