| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup for more than one cell
Worksheet #1 has a lot of data Within the data we have the Word "LIAB" in
column A and # in Column B See Below A B C Aug-05 1103 44,023.151 Jul-05 1103 42,684.574 LIAB 1103 340,573.884 AGED 1103 1,235,569.497 TOTALS 1103 1,576,143.381 Aug-05 1265 365.497 Jul-05 1265 7,012.625 LIAB 1265 64,477.315 AGED 1265 174,469.632 TOTALS 1265 238,946.947 My new spreadsheet #@ has just numbers. A B 1103 1105 1106 How do I do a VLOOK UP to say: look for the numberA1from Sheet #2 in Sheet #1 and if it has the word LIAB in Column A then take the corresponding cell value in sheet #1 column C and put it into column B of Sheet #2 -- Thanks ETC |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Cell Validation List & Linked Cell VLOOKUP | Excel Discussion (Misc queries) | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| VLOOKUP using a cell calculated with NOW returns Error | Excel Worksheet Functions | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
