Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have two worksheets, one is named Db and the other Info. Info is basically
an easy to read record summary and this summary comes from each record in Db. I have a unique number assigned (a record number) for each record on the Db sheet and is located in Column A. I will enter that record number manually in cell D41, on the Info sheet. On the Info sheet, I want cell D29 to first look in D41 and match that record number to the same number in Column A on the Db sheet. Once it finds that number, I want it to list whatever is located in that row's V column. So say that Info!D29 looks in Info!D41 and the number is 765. It now looks in Db!'s A column and finds that Db!A73 is 765, which matches the same record number as Info!D41. So it knows that row 73 is the row number it needs. It then needs to look across the row to column V and whatever is in that cell (Db!V73) is what also now goes in Info!D29. In turn, if there is nothing in the cell, then I want it to also remain blank; I don't want a 0 in there. Phew! Anyway, is this possible? I've NO idea whatsoever how to do this. I've read until my eyes have crossed and I'm still at a loss. I'm using Excel 2003 in Windows XP. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please add Benford Law function into Excel. (IDEA has it). | Excel Discussion (Misc queries) | |||
I Have No Idea How To Do Or Title This! | Excel Worksheet Functions | |||
Implementing an idea ... | Excel Discussion (Misc queries) | |||
Two problems - I have no idea!! | Excel Discussion (Misc queries) | |||
Help Please. No Idea what to look for or how to do this | Excel Discussion (Misc queries) |