Mar 23 2022 09:19 AM
HI there
Need help adding more information to the formula
I am using vlookup but i want to added another formula to it. I have #N/A from the vlookup and when there is #N/A in it, i want to be able to change it to zero.
=VLOOKUP(@A:A,'RAW DATA'!C:F,4,FALSE) this is the
Plus another formula
=IF(B8<0,"CLAWBACK","FILL IN LATER") this is the beginning of it and want to added Vlookup after it
Mar 23 2022 10:34 AM
Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.
Mar 23 2022 12:01 PM
Mar 23 2022 01:14 PM
Mar 28 2022 08:21 AM
Mar 28 2022 08:26 AM
Mar 28 2022 08:47 AM
Mar 28 2022 08:50 AM
Mar 28 2022 08:58 AM
Mar 28 2022 09:04 AM
SolutionMar 28 2022 09:05 AM
Mar 28 2022 09:11 AM
Mar 28 2022 09:20 AM
Mar 28 2022 09:24 AM
Mar 28 2022 09:36 AM
Mar 28 2022 09:51 AM
Mar 28 2022 09:04 AM
Solution