Macros or Formula?

Closed
ORLATSTM Posts 1 Registration date Thursday July 30, 2015 Status Member Last seen July 30, 2015 - Jul 30, 2015 at 12:49 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 30, 2015 at 10:56 AM
I have a report to run for work each week. Simply said, I obtain the raw data and need to sort and filter it based on a certain criteria. Then I need to match and label 1,2,3,4 in column "A" based on what is in that same row for column "BF".

For example, if Cell BF3 = X then A3 =1
if Cell BF4 = Y then A4 = 2

I don't know if a macro is needed or a formula. Thank you for all the help!
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jul 30, 2015 at 10:56 AM
Hi Orlatstm,

For that you can use a formula like this:
=IF(BF3="X",1,IF(BF3="Y",2,""))

Best regards,
Trowa