LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MagnoliaSouth
 
Posts: n/a
Default I've no idea how to do this. :(

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please add Benford Law function into Excel. (IDEA has it). Benford Excel Discussion (Misc queries) 0 May 22nd 06 01:26 AM
I Have No Idea How To Do Or Title This! Maxemily Excel Worksheet Functions 0 March 30th 06 02:32 AM
Implementing an idea ... SunGod87 Excel Discussion (Misc queries) 1 December 19th 05 02:51 PM
Two problems - I have no idea!! Junior Excel Discussion (Misc queries) 2 July 31st 05 09:28 PM
Help Please. No Idea what to look for or how to do this David Chadwick ([email protected]) Excel Discussion (Misc queries) 0 February 28th 05 04:19 PM


All times are GMT +1. The time now is 04:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"