| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If return
I need some help please...
If C2 = A:A than I want it to return the number that is in B:B next to the match of C2 Quick report Number of Line Items Entry Number 3696821-7 1 7076693-1 3696901-7 1 9058675-6 7076693-1 68 8700137-1 8700008-4 2 8700136-3 8700009-2 1 8700135-5 So if 7076693-1 is found in quick report give me 68 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
If return
=vlookup(C2,A2:B100,2,false)
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "nicole" wrote in message ... I need some help please... If C2 = A:A than I want it to return the number that is in B:B next to the match of C2 Quick report Number of Line Items Entry Number 3696821-7 1 7076693-1 3696901-7 1 9058675-6 7076693-1 68 8700137-1 8700008-4 2 8700136-3 8700009-2 1 8700135-5 So if 7076693-1 is found in quick report give me 68 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| Return a value | Excel Worksheet Functions | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| Value Return | Excel Worksheet Functions | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
Hybrid Mode
