| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look for a value in two cells and match it with another
I have many first names in column A and last names in column B and their
corresponding #s farther down in four columns (F:I). I have another list of first and last names at the bottom of the page which I would like excel look for thier match in the same sheet and copy the #s from all 4 columns in the top sheet and paste it to their corresponding columns (F:I) at the bottom sheet. I belive it can be done with Vlookup but I can't get it right. Help please. Thank you. EX. Top of the sheet: ColumnA ColumnB | ColumnF ColumnG ColumnH ColumnI Bob newman 6 45 86 52 Bottom of the sheet: ColumnA ColumnB | ColumnF ColumnG ColumnH ColumnI Bob newman ? ? ? ? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200707/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: match two cells in one sheet to two cells in another and return a third cells value | Excel Worksheet Functions | |||
| Match cells with cells on another workbook | Excel Worksheet Functions | |||
| Trying to get a match on Four of Five cells, which formula is use | Excel Discussion (Misc queries) | |||
| Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) | |||
| Make cells match | Excel Discussion (Misc queries) | |||
Threaded Mode
