If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#6
|
|||
|
|||
Thanks for the help. I know I'll fully understand the formula structure
soon. One question, at end of formula ,4,0 what in fact does the 4 make reference to? "Ragdyer" wrote: Try this: =VLOOKUP(A1, 'Sheet2'!$A$1:$D$10, 4, 0) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "George A. Yorks" .(donotspam) wrote in message ... Thanks for the help. One further question. In the formul In sheet 2 $A$1:$b$10makes reference to two adjacent columns. If there is a column between so there is data in a and c and none in b the result return err,the formula in this cell referes to cells that are currently emply. How to get around this. ie" if sheet two has data in column a and column d. thanks George Yorks "Earl Kiosterud" wrote: George, In B1 of sheet 1: =VLOOKUP(A1, 'Sheet2'!$A$1:$B$10, 2, FALSE) Copy down with fill handle to B10. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "George A. Yorks" .(donotspam) wrote in message ... Trying to create a formula to do the following: Sheet 1 column A a list of personal names a1-a10 Sheet 2 has list of names a1-a10 and list of dollar amounts colums d1-d10 want to search sheet one and if any name from sheet 2 found on sheet 1 than the corresponding dollar amount is entered. Any help appreciated. -- George |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using Mail Merge for Creating a Document of Biographies... | Sam Clarke | General Discussion | 1 | January 4th, 2005 04:28 PM |
Using Mail Merge for Creating a Document of Biographies... | Sam Clarke | Mailmerge | 1 | December 17th, 2004 10:17 AM |
Using Mail Merge for Creating a Document of Biographies... | Sam Clarke | General Discussions | 0 | December 16th, 2004 07:35 PM |
Creating Forms using VBA | Suzi | General Discussion | 1 | November 18th, 2004 03:46 PM |
Problem Creating Report | [email protected] | Using Forms | 1 | June 7th, 2004 07:51 AM |