Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the following situation
Column A Column B Column C M Project# R Project# M0001 R133 M0002 R0060 M0003 R0096 M0004 R0113 M0005 R0153 M0006 R0157 M0007 R0279 M0008 R0280 How do I build a formula on Column C where each time the digits match (A,B) to return the value existing on column B? Ex: Column A Column B Column C M0008 = R0008 repeat R0008 Thank you so much in advance for your help. |