| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If column A = B then pick up value in D.
Hi I have a problem.
I have two columns in different spreadsheets: A B D 27238-2807 27736-1321 D1 27736-1321 27238-2807 D2 27736-1321 27736-1321 D3 27736-1321 27736-1321 D8 27251-3761 27238-2807 D1 I would like to write a formula or VBA the if A = B then pick up the value in column D. Could you please help? Many thanks, Peter. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a pick list from more than one column | Excel Discussion (Misc queries) | |||
| How to random pick a cell from more than one column | Excel Discussion (Misc queries) | |||
| Pick the low number in a column of Numbers | Excel Discussion (Misc queries) | |||
| How do I pick the only number in a column and copy it to another? | Excel Discussion (Misc queries) | |||
| Pick up digist from another column | Excel Worksheet Functions | |||
Threaded Mode
