| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
vlookup should get you there.
"Brian H" wrote in message ... Here's what I can't figure out how to do, I have two lists of checks, each formatted with first column check number and second column check amount: CK# Amount CK# Amount 101 525.35 104 425.50 102 225.45 101 525.35 103 400.00 105 115.00 104 425.50 102 225.45 105 115.00 103 400.00 I've searched for a worksheet function that will look at a check number in the first list, search for it in the second list, and if found, return the check amount value to a cell. Grateful for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Benefits many people - Question | Excel Discussion (Misc queries) | |||
| Possibly a loaded question, but I think | Excel Discussion (Misc queries) | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| An easy macro question and one I believe to be a little more diffi | Excel Worksheet Functions | |||
Hybrid Mode
