| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if / match
In spreadsheet 1, have a spreadsheet which has peoples names, job numbers
and the number of hours they worked on various jobs. Spreadsheet 1 Col A Col B Col C Row1. Job# 1 Job #2 Row2 Mr A.. 54hr 21hr etc Etc Spreadsheet 2 Row 1ColA (col b)Mr A. Mr B. Mr. C Job#1 ** Job#2 etc ** (I want a function that will look for the job# and the person's name in spreadhseet 1 and if the name matches and the hrs for that Job3 in spreadsheet 1, then put the persons name (e.g B1 Mr A.) in this cell in spreadsheet 2. What is the best way to do this? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
| Any way for 2 column vlookups. i.e match last name then match firs | Excel Worksheet Functions | |||
| index,match,match on un-sorted data | Excel Worksheet Functions | |||
| When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)... | Excel Worksheet Functions | |||
Threaded Mode
